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?
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?
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.
"glenn" wrote:
> 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?
Take a look at Format|conditional formatting.
glenn wrote:
>
> 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?
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks