Conditional Formatting Quartely Months

  • Thread starter Thread starter malycom
  • Start date Start date
M

malycom

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
 
CF's in the order.

'condition 1
=AND(A1<>"",MONTH(A1)<=3)

'condition 2
=AND(A1<>"",MONTH(A1)<=6)

'condition 3
=AND(A1<>"",MONTH(A1)<=9)


If this post helps click Yes
 
Back
Top