Conditional Format Calendar if Date Matches Range of Dates in Other Cells

Hi,

So I have a calendar which already has 2 CF rules. It highlights days on a 5 - 5 - 2 - 2 basis and it then highlights non blank cells. Basically it's a shared custody calendar, it splits up the year 50/50 between me and my ex in bright colours so there's no confusion over who has the kids.

I'm now trying to figure out how I can use further CF to highlight all the school holidays that my kids will be with me but I'm struggling to find someone who has done something similar in this forum or others.

What I have is attached, any help someone could offer will be greatly appreciated.

The range of dates is in the AK column to the right of the table. I've attached to make life easier.

It's a shame I can't give reputation for myself...

Highlight month, conditional format, new rule, classic, use formula,

=NOT(ISERROR(MATCH(AA25:AG30,$AK$14:$AK$39,0)))

Originally Posted by etaf

try
=AND(COUNTIF($AK:$AK,C7)>0, C7<>"")
and apply to the range
=$C$7:$AG$30

so you only need enter once for the entire sheet

That would have been great but it didn't seem to work.

Originally Posted by etaf

worked on my sample OK
so can you load your sample, with the new condition in - so we can see what the difference maybe?

did you make sure that the order was set to do this new condition first - use the arrow on the cond format box to change order and then use
stop if true
otherwise , the other conditions will overwrite the holidays - you have 2 conditions apply to the same cell

I had just figured out that I had the order wrong and came back here to apologise but you'd already responded. Works like a charm, thanks.