Macro to change text colour
 

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.

Macro to change text colour
 

Have you tried Conditional Format yet?

"FJ Shepley & JM Pfohl" ¼¶¼g©ó¶l¥ó
...
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.