date flashing

G

gummertwo

hi, i am asking if you can, if so how the date flashes up in excel. in
example if u have a load of cars when there mots are due and you have
all the dates in, and i want it to flash up a colour(red) when it
reaches that date so you know when to mot it.
 
A

Anand Iyer

Hi;

Try the =today() formula
As mentioned in an earlier reply do a conditional format to check if
the due date is greater than =today().

This ought to do the trick.

Regards

Anand Iyer
 
Top