Does excel have a running calander

G

glenn

I want to enter dates in cells for scheduling and when that date comes for
excel to change the fill color on those cells. Can this be done and if so how?
 
B

bpeltzer

Use conditional formatting. In the cell where this should happen, Format >
Conditional Formatting. Set the condition as 'Cell Value Is', 'Greater Than
or Equal To', =today(). Then click the format button, select the 'Pattern'
tab and choose your fill color.
 
D

Dave Peterson

Take a look at Format|conditional formatting.
I want to enter dates in cells for scheduling and when that date comes for
excel to change the fill color on those cells. Can this be done and if so how?
Click to expand...
 
Top