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 cell has been marked as 'complete'. The first 2 work ok, but I can't get the black conditional format to work for the completed cells. Any ideas
I think the attached version does what you want, with 5 rules, one for each color (black, green, light blue, amber and red).
How your data is structured? Date is one cell and "complete" (whatever) is in another and which one, or what?
SergeiBaklan Thanks for getting back to me. Date is in one cell, with status in another cell. I have several rules in place, which might be complicating things. Trying to get the conditional formatting in the column next to the status column. The red cells should be black because the date is in the past the column next to it reads 'completed'. Does that make sense?
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.
