How to Make another column mandatory based on a value set in another column in Excel?
I have two columns in Excel.
Yes This become mandatory
No Then Optional
so if the value1 column has Yes then Value2 should become mandatory else it can stay empty. The user should not be allowed to save the sheet if the col1 has yes and col2 is empty.