Conditional format to colour cells

L

lunar1085

I need to compare a scheduled date to today's date and colour/blink a
cell based on results, e.g. steady green would be on time, steady amber
still on time but getting close (2 weeks before due date), flashing red
is past due.
Thanks for your help
 
B

Bernard Liengme

Use Format|Conditional Formatting
Formula will be something like =(A1-TODAY())<15 then give a colour
Add more conditions; pass due would be =A1<TODAY()
Thankfully Microsoft did not provide flashing!
 
Top