Conditional Formatting Quartely Months
 

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

Conditional Formatting Quartely Months
 

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

Conditional Formatting Quartely Months
 

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