How can I validate columns in my spreadsheet based on values in other columns?
1. If a User Enter a Value in Column A, then columns B, C, D MUST also be completed(cannot be left blank)
2. If the value is "Yes" in Column N, then Column O should also have a value
3. If Column "N" is Blank, then Column "O" must also be blank.
Your prompt response is much appreciated.