Is it possible to automatically change color of cell by keying off the date?

J

joe54345

I have a spreadsheet that I update daily for tasks. I have been
manually entering the dates when each task is finished by clicking
ctrl-; My question is if it's possible to have the color of the cell
change at midnight automatically on the date the task is overdue. I
know this is a longshot but if excel won't allow me to automatically
change the color is there any other changes I can make to the cell so I
can automatically see that a task is overdue aside from manually
scanning down the page?
 
C

ChuckF

Somewhere on the sheet add the formula =today(). This will let your
spreadsheet know what today's date is. From there you can simply add
Conditional Format to your selected date field. (Highlight the "due
date field" go to 'Format, Conditional Formatting, and enter as follows
CELL VALUE IS Greater Than (Whatever cell you put your =today()
formula.

This should give you your desired effect.

HTH
 
J

joe54345

thanks for this Chuck, it works great. I've even found that I can set
up tasks that are due every other day by putting a -1 at the end of the
tag.
 
Top