Conditional format dates based on year/quarter

[Beau the dog]

So, I have a list of data (obviously!). I want to highlight the rows based on which year and which quarter I select. I realise this is purely for aesthetics, but I'm a little OCD with that! The word "Quarter" is in Cell A1. So I've selected 4th quarter and year 2021 in cells B1 and C1 respectively, so row 3,4 and 5 should be highlighted, I'd like to colour entire rows please.

Quarter	4	2021
Month	Pass	Fail	Pass %
Oct-21	4	0	100%
Nov-21	7	3	70%
Dec-21	5	0	100%
Jan-22	2	0	100%
Feb-22	2	0	100%
Mar-22	4	1	80%
Apr-22	6	0	100%
May-22	3	0	100%
Jun-22	2	2	50%
Jul-22	1		100%
Aug-22	5	0	100%
Sep-22	2	0	100%
Oct-22	4	0	100%
Nov-22	6	0	100%
Dec-22	4	1	80%

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D
1	Quarter	2	2022
2	Month	Pass	Fail	Pass %
3	Oct-21	4	0	100%
4	Nov-21	7	3	70%
5	Dec-21	5	0	100%
6	Jan-22	2	0	100%
7	Feb-22	2	0	100%
8	Mar-22	4	1	80%
9	Apr-22	6	0	100%
10	May-22	3	0	100%
11	Jun-22	2	2	50%
12	Jul-22	1		100%
13	Aug-22	5	0	100%
14	Sep-22	2	0	100%
15	Oct-22	4	0	100%
16	Nov-22	6	0	100%
17	Dec-22	4	1	80%
18
19
Lists

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:D100	Expression	=AND(YEAR($A3)=$C$1,MEDIAN(MONTH($A3),$B$1*3,$B$1*3-2)=MONTH($A3))	text	NO

 

[etaf]

how about
=AND(ROUNDUP(MONTH($A3)/3,0)=$B$1, YEAR($A3)=$C$1)

Book1
	A	B	C	D
1	Quarter	4	2021
2	Month	Pass	Fail	Pass %
3	Oct-21	4	0	100%
4	Nov-21	7	3	70%
5	Dec-21	5	0	100%
6	Jan-22	2	0	100%
7	Feb-22	2	0	100%
8	Mar-22	4	1	80%
9	Apr-22	6	0	100%
10	May-22	3	0	100%
11	Jun-22	2	2	50%
12	Jul-22	1		100%
13	Aug-22	5	0	100%
14	Sep-22	2	0	100%
15	Oct-22	4	0	100%
16	Nov-22	6	0	100%
17	Dec-22	4	1	80%
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:D17	Expression	=AND(ROUNDUP(MONTH($A3)/3,0)=$B$1, YEAR($A3)=$C$1)	text	NO

 

[Beau the dog]

Both of these solutions work perfectly, thank you both

I flipped a coin as who to mark as solution!!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[etaf]

you are welcome