I need some assistance with creating a validation check (formula).
Here's what I have in the Excel file:
- Columns D:F may have a cell values = "True"
Here's what I need to check:
- If cells in either column D or column E have a value of "True", then I must validate whether or not I have a value of "True" in associated cells in either column G or column H.
For example, if either cell D2 or E2 has a checked checkbox (value of "True"), then I must also have a checked checkbox in either G2 or H2. If G2 *or* H2 don't have a value = True, I want to display a message indicating "Please select a value in column G or H).
Any ideas how to create such IF statement?