It does not work like that for excel 2007 there is alot more options but i
have done it another way thank for your help anyway.

"vezerid" wrote:

When you first open the dialog box it has place for one condition. You
change the dropdown that says Cell Value Is to Formula Is. You supply
the first formula. For this condition you click the Format button and
in the patterns tab you choose the color green.

Then you click a button that says add. This creates space for the 2nd
condition. You repeat the procedure w/ the 2nd formula and 2nd format.

Then you click add again and add 3rd formula and condition.

HTH
Kostis

On Nov 16, 5:11 pm, markwmansell
wrote:
OK i did all that but it only usings the formula that is at the of the rule
list please can you tell me how i can get all 3 working at once?

"vezerid" wrote:
Select all cells that you want to CF. Say the first one in the
selection is A2. Format Conditional Formatting...

Choose Formula Is:

=TODAY()-A2<3
=(TODAY()-A2=3)*(TODAY()-A2<5)
=TODAY()-A2=5

Use Add to input the 2nd and 3rd formula. Choose the appropriate
format for each.

HTH
Kostis Vezerides

On Nov 16, 3:28 am, markwmansell
wrote:
umPlease please can some one please help me i'm tyring to get a list of dates
to change if its
today to 3 days old to turn green,
3 days old to 5 days old to turn yellow and
over 5 days old to turn to red?
Im using excel 2007 im new at this so please make it simple :).

plus

Is there a way of puting dates down a column with out having to drag it down?