can I change font color for a date which is appoaching to act as

B

Brian

I am using Excel and have added a date to a cell. I want to set up some form
of alert on an impending date and wondered whether I could arrange for the
date to change font colour "x" number of days before the date.

Regards
 
F

FSt1

hi
conditional fomating.
on the menu bar..
format>conditional formating
cell value is........less than........=now()-7....pick your format.

for this example, i chose 7(days). change it if needed.

Regards
FSt1
 
Top