Forum Discussion
Solved
Conditional formatting
Hi All, I have one cell with date and another one with the criteria False or True. I'd like to colour a third cell based on past dates and the False criteria. I have tried many ways but cant figure out the correct formula.
Appreciate any help.
Ana_Ferr75 Try this simple formula in custom conditional formatting rule-
=AND(A1<TODAY(),D1=FALSE())
Ana_Ferr75 Try this simple formula in custom conditional formatting rule-
=AND(A1<TODAY(),D1=FALSE())Hi Harun24HR, thank you so much!
You solved it in a very simple way.
I was expecting something much more complex
Regards, Ana
