Hi

Is there a way to conditionally format a column of dates just using the days
and months and not including the year?

For instance, the column I have is hundreds of dates set using this type of
format and in no particular date order
31/03/2009
12/01/2008
15/08/2009
16/05/2001
02/11/1998
etc

What I want to happen is wherever a date is between 01/01/YEAR and
31/03/YEAR, to automatically turn the font red and where the date is between
01/04/YEAR and 30/06/YEAR, to have this font colored blue and the same for
the next two quarters.

The year can be ignored. Any dates within a quarter period regardless of
the year is to have it's own color.

Is this possible and if so, can anyone help.

Thanks in advance

Mal