Conditional formatting

Select cell with date
select conditional formatting

Condition 1
Cell value is Equal to =Today() and select your colour
Press add
Condition 2
Cell value is less than ="<today()" and select your colour


To apply that format to yor range of cells select that range ensuring the
cell you have already formatted is included. Click format - conditional
formatting - OK

"Daniel Bunt" wrote:

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 :)