Conditional format to colour cells

  • Thread starter Thread starter lunar1085
  • Start date Start date
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
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting in Excel 2010 2
Excel Colour code dates 1
Fill Colour problem 2
Using CF to change colour in cell based on date? 4
Change cell colour 2
Conditional formatting 1
Help calculating trend by colours/taking last value per month. Thanks for all efforts 0
Excel Conditioning Formatting 3

Back
Top