Help with Dynamic Calendar_Incorrect Event Text Color

Try for 1st row: CF formula: =SUM(DAY(B7:$AC7))>20
For last 2 rows: CF formula: =SUM(DAY(B23:$AC23))<20

@josephteh,
It doesn't work for me.

With attached workbook with the CF formulas.

@josephteh,
I’ve got it working for gray dates (event text turns gray when the date is gray), but I’m running into an issue with dark black dates.
I’ve already set up conditional formatting based on the date's color, but it seems like the black color isn’t triggering the desired text color change.

Please be specific, with the month April 2025 selected, which cell(s) you are referring to.

@josephtech
Please see the screenshot and file attached for your reference.
Image_Dynamic-Event-and-Holiday-Calendar-in-Excel - Test 2 (JT) - Excel.png

Thanks for your help.

Try,
CF formula: =IsCurrentMonth=FALSE, applies to: =$B$7:$AC$30
CF formula: =TEXT(E7,"mmmm")<>Selected_Month, applies to: =$B$8:$AC$10,$B$12:$AC$14,$B$16:$AC$18,$B$20:$AC$22,$B$24:$AC$26,$B$28:$M$30
CF formula: =MATCH(B7,List!$J$3:$J$161,0)>0, applies to: =$B$7:$AC$30,$AE$10:$AK$15,$AE$20:$AK$25

@Thanks for trying, but same output.

Your comment is totally not helpful. I put in the effort, and this is the best you can do? I am out.