Highlighting countrywise Holidays in a calendar

Hi,

Here in my sheet, i need to highlight the countrywise holiday details based on the holiday list table by using conditional formating.

I can do this based on country specific for each line item, but countries names are not in order every month. Hence, please help in building the fomuala in such a way that it should highlight if country comes anywhere in the cell in Column A.

Thanks.

The formula for CF:

=COUNTIF(INDEX($B$14:$G$16,MATCH($A4,$A$14:$A$16,0),0),B$3)

=OR(B$3=MINIFS($B$14:$B$16,$A$14:$A$16,$A4),B$3=MAXIFS($C$14:$C$16,$A$14:$A$16,$A4))


applies to=$B$4:$AF$11

Thanks a lot...