Forum Discussion
Conditional Formatting
How do I conditionally format a column of dates? I have forecast dates from a supplier which I want to colour red if it is 2 weeks late, amber if 1 week late and green if on target?
If your dates are in column A starting from cell A1, for the red colour you may create the rule with the formula
=(TODAY()-$A1)>=14
and apply it to your entire range.
Similar for another two rules.