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?