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?