Conditional Formatting Quartely Months

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Week Number Format 4
Date Difference in Complete Tax Years 1
If cell = now – current Qtr – 28 days then RED 3
Specific Date from a Range 3
IF and AND formula for date field 6
IF or vlookup formula 8
Calculating Months within a specific period 6
COUNT BETWEEN A SPECIFIC DATE RANGE 4

Top