Forum Discussion
Solved
Conditional Formatting multiple rules
I am trying to conditionally format a cell that is green for dates in the future (from today), red for dates in the past (before today) and black for two criteria, 1) date in the past and 2) when a c...
I think the attached version does what you want, with 5 rules, one for each color (black, green, light blue, amber and red).
In addition, much better to follow "one rule = one format". In your case first three could be combined as
=AND( G13 <> "In progress", E13>= $A$1) + AND( G13 <> "Not started", E13> $A$1 )or like for the green.
Thanks for this, I have applied the above formula and it works but I still can't get the black RAG to work, using the completed status.