Forum Discussion
Conditional Formatting--Relative References Not Working Correctly
I am trying to set up a relatively simple calendar that automatically updates for changes in our company being opened or closed and uses another planning worksheet to update changes. Anyway, I am...
Hi David,
With relative references you shall includes all combinations in your rule. Perhaps could be simplified, but looks like
=OR(OR(AND(I13<15,J13="CLOSED"),AND(I12<15,J12="CLOSED")),OR(AND(H13<15,I13="CLOSED"),AND(H12<15,I12="CLOSED")))
With your rule if it check cell J13 it highlights the cell if J13 <15 and K13= CLOSED, etc.
Thank you, Sergei.
I think I understand what needs to happen. It took me a few minutes to wrap my head around how the references work with your explanation.
I will see how it goes.
Each of my cells will have multiple conditions.
Thanks again.