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).
I think the attached version does what you want, with 5 rules, one for each color (black, green, light blue, amber and red).
Genius! This is exactly what I was looking for 🙂 Thanks so much