have a Named Range in a sheet as follows
ROW 1 2018 2019 2020 2021 2022 2023 2024 2025
ROW 2 1/1/18 1/1/19 1/1/20
ROW 3 26/1/18 26/1/19
ROW 4
ROW 5
*****
****
***
**
*
*
ROW 13 26/12/18

It is list of Public Holidays from 2018 - 2025 in cells A2:H13. I use them as a Named Range "PH"

In a separate sheet i have a formula that places a date down in column 1 A4:A10

What i would like to do is use CD to highlight a cell, IF a Public Holiday occurs in one of those days in A4:A10.

The Date format is different from the Named Range (Long Date) to the Dates(d mmm) in the other sheet also.

I've tried a few different formula's but can't seem to get the correct syntax to highlight the cell of a public holiday.

Any assistance?