Macro to change text colour

[FJ Shepley & JM Pfohl]

I want text to change colour depending on the date.
In Col A is the date
in Cols B to L are order numbers.

I want the order numbers to be RED if Col A is today, Black if date is
yesterday and Green if date is tomorrow.

Is this possible?

Thanks,
Frank.

 

[Eddy]

Have you tried Conditional Format yet?

 

[Anne Troy]

Conditional Formatting for more than 4 conditions:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=90
________________________

**** Hope it helps! ****

~Dreamboat
www.VBAExpress.com/forum
************************