How do I have the date in a spreadsheet change automically.
 

I have created a spreadsheet in Excel 2003. This spreadsheet lists
contractors and whether or not they have public liability or workcover
insurance. The spreadsheet shows what date their insurance expires on. I
would like to know if it is possible for the cells to change colour
automically when the date changes. For example if the date expires on the
31/8/06 can I set up a formula to have the cell change from red to green
after I change the date in the cell. Also is there a way for the cell to
change automically from red to green without me having to change the date in
the cell manually. If anyone knows if this is possible could they please let
me know. Thank you.

How do I have the date in a spreadsheet change automically.
 

Use conditional formatting. If you want a format to be applied when the date
in the cell is in the past, click the cell, then Format Conditional
Formatting. Leave the drop-down as 'Cell Value Is', set the second drop-down
to 'Less Than' and enter a formula in the text box: =TODAY(). Then click on
Format, click the Patterns tab and choose the color you'd like, then click OK
twice.

"VC" wrote:

I have created a spreadsheet in Excel 2003. This spreadsheet lists
contractors and whether or not they have public liability or workcover
insurance. The spreadsheet shows what date their insurance expires on. I
would like to know if it is possible for the cells to change colour
automically when the date changes. For example if the date expires on the
31/8/06 can I set up a formula to have the cell change from red to green
after I change the date in the cell. Also is there a way for the cell to
change automically from red to green without me having to change the date in
the cell manually. If anyone knows if this is possible could they please let
me know. Thank you.