date flashing

[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.

 

[L. Howard Kittle]

Take a look at Conditional Formatting under Format.

HTH
Regards,
Howard

 

[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