Toogit Social Post

Reena Shah

9 months ago
How to Make another column mandatory based on a value set in another column in Excel?

I have two columns in Excel.

Value1 Value2
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.
4 comments, 0 Followers

No comments yet!