Can anyone provide me with Step By Step instructions to do the following
please..

Dates are listed from A9:A39 (Month Of January) they show as 01 January 2007
What is the process i need to go throguh to get the FILL color of a box to
change Permanently to another colour, once the date has been reach and
recognised when the excel sheet is opened?

Eg: today is 07 January 2007 and the fill color is allready light blue on A15.
i open excel on the 08 January 2007.. what i want here is for the fill color
for 07 January to have changed to a Orange. (permanently) as it is a past
date.

This one probably cant be done... itll no doubt get you guys thinking.. If
you wanted a challenge.. here it is. ( or maybe not )

What i will need is..

Hi Dan, Do this... Click on ?? then on ??? then type ???? then select rage
??? etc etc right click on..........

Thnx guys :)