Conditional Formatting of Specific Months (e.g. Quarters)

[Ultramaficjerm]

Howdy all,

I've been tying to find solution for a conditional formatting need for hours and would love to throw this to the group. I need to 'distill' data on a quarterly basis from a larger dataset. My thought is that I could simply copy over the larger dataset into separate tabs and conditionally format Column A (using different colors) based on whether the month falls between 1 and 3; 4 and 6; 7 and 9; and 10 and 12 (giving me color-codes based on the four quarters of a given year). At this point, I've had to create a row and insert the month formula (=Month(A1)) and conditionally format based on THAT column....BUT is there a way to conditionally format on the actual date column to highlight based on the months (e.g. Jan-Mar, Apr-Jun, and so on)? BTW, dates are in Column A and additional data in Cols B and C.

Hopefully that makes some sense!

Many thanks in advance,

J

 

[steve the fish]

Highlight cells or column required, press conditional formatting, new rule.
In the dialog box select 'use a formula to determine which cells to format'
In the format values box type:

=MONTH(A1)<13

Click format and do whatever you want here. Then ok.

Repeat for:

=MONTH(A1)<10
=MONTH(A1)<7
=MONTH(A1)<4

and finally:

=ISBLANK(A1) but leave format button for this one.

Click conditional formatting again. Manage rules. Tick stop if true for the ISBLANK part

Done!