Morning Chaps,

I'm having a small problem with Highlighting a row when a date is a Stat Holiday.

On the example in yellow are the two formulas that I have tried, both will only colour Column 'A' even though I have the full range set in the CF Rule.

Any ideas or pointing out what I am missing will be greatly appreciated.

Employee Schedule-Vertical.xlsx