Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does excel have a running calander
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does excel have a running calander
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Does excel have a running calander
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Urgent Help needed - I need to stop a process that is running forever in Excel | Excel Discussion (Misc queries) | |||
Running Excel events even in edit mode.... | Excel Discussion (Misc queries) | |||
can excel change number 1532 to 1235 running order | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |