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.