Highlight Cells with dates of Even Months

[dyscea]

I wanted a 2023 calendar w/ consecutive dates. I would like it if I could Conditional Format cells whose dates contain Even Months.

Like so:

I tried to figure it out, even from an old 2006 post from here, but my brain is fried.

Thanks in advance!

 

[JGordon11]

Book1
	A	B	C	D	E	F	G	H
1	10/12/2022	10/13/2022	10/14/2022	10/15/2022	10/16/2022	10/17/2022	10/18/2022
2	10/19/2022	10/20/2022	10/21/2022	10/22/2022	10/23/2022	10/24/2022	10/25/2022
3	10/26/2022	10/27/2022	10/28/2022	10/29/2022	10/30/2022	10/31/2022	11/1/2022
4	11/2/2022	11/3/2022	11/4/2022	11/5/2022	11/6/2022	11/7/2022	11/8/2022
5	11/9/2022	11/10/2022	11/11/2022	11/12/2022	11/13/2022	11/14/2022	11/15/2022
6	11/16/2022	11/17/2022	11/18/2022	11/19/2022	11/20/2022	11/21/2022	11/22/2022
7	11/23/2022	11/24/2022	11/25/2022	11/26/2022	11/27/2022	11/28/2022	11/29/2022
8	11/30/2022	12/1/2022	12/2/2022	12/3/2022	12/4/2022	12/5/2022	12/6/2022
9	12/7/2022	12/8/2022	12/9/2022	12/10/2022	12/11/2022	12/12/2022	12/13/2022
10	12/14/2022	12/15/2022	12/16/2022	12/17/2022	12/18/2022	12/19/2022	12/20/2022
11	12/21/2022	12/22/2022	12/23/2022	12/24/2022	12/25/2022	12/26/2022	12/27/2022
12	12/28/2022	12/29/2022	12/30/2022	12/31/2022	1/1/2023	1/2/2023	1/3/2023
13	1/4/2023	1/5/2023	1/6/2023	1/7/2023	1/8/2023	1/9/2023	1/10/2023
14	1/11/2023	1/12/2023	1/13/2023	1/14/2023	1/15/2023	1/16/2023	1/17/2023
15	1/18/2023	1/19/2023	1/20/2023	1/21/2023	1/22/2023	1/23/2023	1/24/2023
16	1/25/2023	1/26/2023	1/27/2023	1/28/2023	1/29/2023	1/30/2023	1/31/2023
17	2/1/2023	2/2/2023	2/3/2023	2/4/2023	2/5/2023	2/6/2023	2/7/2023
18	2/8/2023	2/9/2023	2/10/2023	2/11/2023	2/12/2023	2/13/2023	2/14/2023
19	2/15/2023	2/16/2023	2/17/2023	2/18/2023	2/19/2023	2/20/2023	2/21/2023
20	2/22/2023	2/23/2023	2/24/2023	2/25/2023	2/26/2023	2/27/2023	2/28/2023
21	3/1/2023	3/2/2023	3/3/2023	3/4/2023	3/5/2023	3/6/2023	3/7/2023
22	3/8/2023	3/9/2023	3/10/2023	3/11/2023	3/12/2023	3/13/2023	3/14/2023
23	3/15/2023	3/16/2023	3/17/2023	3/18/2023	3/19/2023	3/20/2023	3/21/2023
24	3/22/2023	3/23/2023	3/24/2023	3/25/2023	3/26/2023	3/27/2023	3/28/2023
25
Sheet1

Cell Formulas
Range	Formula
A1:G24	A1	=SEQUENCE(24,7,TODAY())
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:G24	Expression	=ISEVEN(MONTH(A1))	text	NO

 

[Micron]

Did you try Mod function on the month portion of the cell values? E.G. if value was an even number, this would format the cell (I used 90 as a value).

=MOD(D12, 2) =0

Edit - using your single month digit values:
=MOD(LEFT(D12,1), 2) =0

 

[dyscea]

JGordon11, thank you. I actually saw your reply right away but couldn't get it to work. After a good night's sleep, I tackled it again.

Never heard of dynamic arrays. I hope to be able to use it again. It's nifty.

THANK YOU!!

 

[dyscea]

Did you try Mod function on the month portion of the cell values? E.G. if value was an even number, this would format the cell (I used 90 as a value).

=MOD(D12, 2) =0

Edit - using your single month digit values:
=MOD(LEFT(D12,1), 2) =0

Ya know, I'm usually pretty good at deciphering things, but I couldn't wrap my head around the Mod function when solving this one issue. Mostly because I have an idea on how it SHOULD work, and the functions don't follow my reasoning.

It is just neat enough, I might go find some vids proper vids about it.

Thank you!

 

[Dave Patton]

T202210a.xlsm
	A	B	C	D	E
1	Text			Dates
2	1/1	FALSE		13-Oct-22	TRUE
3	2/22	TRUE		25-Jan-22	FALSE
4	3/8	FALSE
5
2a

Cell Formulas
Range	Formula
E2:E3	E2	=MOD(MONTH(D2),2)=0
B2:B4	B2	=MOD(LEFT(A2,1),2)=0

 

[Dave Patton]

T202210a.xlsm
	A	B	C	D	E
1	Text			Dates
2	1/1	FALSE		13-Oct-22	TRUE
3	2/22	TRUE		25-Jan-22	FALSE
4	3/8	FALSE
5	12/15	TRUE
6
2a

Cell Formulas
Range	Formula
E2:E3	E2	=MOD(MONTH(D2),2)=0
B2:B5	B2	=MOD(LEFT(A2,FIND("/",A2)-1),2)=0