Odd Quarterly date, Conditional Formatting

[Sikorsky27]

Trying to set conditional formatting rule to do color for each Quarter. Quarter 1 starts 01 February to April 30th. I have tried to highlights between dates but I don't want to have to keep adding conditions every quarter to meet the standard. I would like it to populate automatically pending date/quarter it falls under.

Quarters: Beginning of Month to the end of the month listed.

1=February to April
2=May to July
3=August to October
4=November to January

Earliest date started in August of 2019 and I need it to go indefinitely forward from Aug 2019 time period.

Thank you for whom ever assist me.

CKL Status.xlsm
	AB
1	Date of Entry
2	3/1/2021
3	12/15/2019
4	9/3/2019
5	6/15/2021
6	4/30/2021
7	8/28/2019
8	2/19/2020
9	2/9/2021
10	12/15/2019
11	6/25/2021
12	2/9/2021
13	2/19/2020
14	9/10/2021
15	3/25/2021
16	9/22/2020
17	4/30/2021
18	12/15/2019
19	2/2/2020
20	3/31/2020
21	1/18/2021
22	3/1/2021
23	3/1/2021
24	9/9/2019
25	9/9/2019
26	12/15/2019
27	5/20/2020
28	5/27/2020
Data

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AB2:AB400	Cell Value	between 43497 and 43585	text	NO

 

[Joe4]

You haven't told us which quarters should be which colors.
Also, do we care which year the quater is in?
Should Quarter 1 of 2020 be the same color of Quarter 1 in 2021?

 

[Sikorsky27]

You haven't told us which quarters should be which colors.
Also, do we care which year the quater is in?
Should Quarter 1 of 2020 be the same color of Quarter 1 in 2021?

I am using same color's per quarter no matter what year... just breaking down what is in which Quarter that is all. I have selected colors: Q1 Red 0, Green 176, Blue 80... Q2 Red 255, Green 255, Blue 0... Q3 Red 255, Green 255, Blue 204... Q4 Red 198, Green 224, Blue 180

 

[Fluff]

How about

+Fluff 1.xlsm
	AB
1	Date of Entry
2	01/03/2021
3	15/12/2019
4	03/09/2019
5	15/06/2021
6	30/04/2021
7	28/08/2019
8	19/02/2020
9	09/02/2021
10	15/12/2019
11	25/06/2021
12	09/02/2021
13	19/02/2020
14	10/09/2021
15	25/03/2021
16	22/09/2020
17	30/04/2021
18	15/12/2019
19	02/02/2020
20	31/03/2020
21	18/01/2021
22	01/03/2021
23	01/03/2021
24	09/09/2019
25	09/09/2019
26	15/12/2019
27	20/05/2020
28	27/05/2020
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AB2:AB28	Expression	=MEDIAN(MONTH(AB2),8,10)=MONTH(AB2)	text	NO
AB2:AB28	Expression	=OR(MONTH(AB2)>10,MONTH(AB2)=1)	text	NO
AB2:AB28	Expression	=MEDIAN(MONTH(AB2),5,7)=MONTH(AB2)	text	NO
AB2:AB28	Expression	=MEDIAN(MONTH(AB2),2,4)=MONTH(AB2)	text	NO

 

[Joe4]

OK, use the Formula option for Conditional Formatting, select AB2:AB400, then enter this for the first formula (for quarter 1):

=IF(MONTH(AB2)=1,4,ROUNDUP((MONTH(AB2)-1)/3,0))=1

and choose your red color.

Repeat the same formula for the other three CF rules, just changing the "1" in red at the end to "2" for quarter 2, etc, etc for the rest.

 

[Sikorsky27]

How about

+Fluff 1.xlsm
	AB
1	Date of Entry
2	01/03/2021
3	15/12/2019
4	03/09/2019
5	15/06/2021
6	30/04/2021
7	28/08/2019
8	19/02/2020
9	09/02/2021
10	15/12/2019
11	25/06/2021
12	09/02/2021
13	19/02/2020
14	10/09/2021
15	25/03/2021
16	22/09/2020
17	30/04/2021
18	15/12/2019
19	02/02/2020
20	31/03/2020
21	18/01/2021
22	01/03/2021
23	01/03/2021
24	09/09/2019
25	09/09/2019
26	15/12/2019
27	20/05/2020
28	27/05/2020
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AB2:AB28	Expression	=MEDIAN(MONTH(AB2),8,10)=MONTH(AB2)	text	NO
AB2:AB28	Expression	=OR(MONTH(AB2)>10,MONTH(AB2)=1)	text	NO
AB2:AB28	Expression	=MEDIAN(MONTH(AB2),5,7)=MONTH(AB2)	text	NO
AB2:AB28	Expression	=MEDIAN(MONTH(AB2),2,4)=MONTH(AB2)	text	NO

You my friend are amazing, thank you and works beautifully!!

 

[Fluff]

Glad we could help & thanks for the feedback.