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

#### Ultramaficjerm

##### New Member
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!

J

Last edited:

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
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!

Last edited:

Replies
17
Views
1K
Replies
17
Views
2K
Replies
3
Views
286
Replies
3
Views
258
Replies
7
Views
110

1,219,798
Messages
6,150,318
Members
450,951
Latest member
kh198

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back