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
---------------
Jacob Skaria


"malycom" wrote:

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

Jacob

What a star

Thanks very much. It worked a treat.

Cheers

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"malycom" wrote:

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