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

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

Hi Daniel,

Select your range of cells.
Goto FormatConditional Formattimg
Under Condition 1 select cell value is (it is set to that by default)
In the next pulldown select 'greater than'
In the third box type =TODAY()
Click the format button
Go to the Pattern tab and select light blue
Then click add
and repeat the process with condition 2 except that this time
you will select 'less than' and 'orange'
Click OK and you're done

HTH
Martin

Hello World,

How would I create a color pulldown for a cell?

Thx,

Ken

"MartinW" wrote:

Hi Daniel,

Select your range of cells.
Goto FormatConditional Formattimg
Under Condition 1 select cell value is (it is set to that by default)
In the next pulldown select 'greater than'
In the third box type =TODAY()
Click the format button
Go to the Pattern tab and select light blue
Then click add
and repeat the process with condition 2 except that this time
you will select 'less than' and 'orange'
Click OK and you're done

HTH
Martin

The color pulldown is on the Toolbar.

ExNov wrote:

Hello World,

How would I create a color pulldown for a cell?

Thx,

Ken

"MartinW" wrote:


Hi Daniel,

Select your range of cells.
Goto FormatConditional Formattimg
Under Condition 1 select cell value is (it is set to that by default)
In the next pulldown select 'greater than'
In the third box type =TODAY()
Click the format button
Go to the Pattern tab and select light blue
Then click add
and repeat the process with condition 2 except that this time
you will select 'less than' and 'orange'
Click OK and you're done

HTH
Martin