Forum Discussion
Conditional Formatting with Dates
Could anyone help me with the formula so I can enter in conditional formatting. What I’d like to do is have the third column flag up when someone’s date is approaching with say 2 weeks notice (t...
NikolinoDE Thank you !!! I have tried but I am not sure is it right or not, can you confirm
Amber =TODAY()+14<C2
Red =AND(TODAY()>C2,C2<>"")
Looking forward
Here is an example file...
If it's over the date, then RED
If it is between 1 day and 14 days before the date then YELLOW
If it is 15 days before the date WHITE