Conditional formatting is the facility doing such jobs. In Excel2003 and
below you can set max 3 conditions, in Excel2007 there is no limit.

Regards,
Stefi

€žHilly€� ezt Ã*rta:

Hi ,
I am trying to set upo a spreadsheet to track stock market
purchases,dividends etc.
I have date columns, however I would like to be able to color code the dates.
Say blue for dates between 01/07/2006 and 30/o6/2007
red for 01/07/2007 to 30/06/2008
green for 01/07/2008 to 30/06/2009 etc

is there a formula I can input to set this up?