Networkdays but excluding holidays for conditional formatting

[SandsB]

Column A contains dates. I have a named range called Holidays (=Sheet2!$A$1:$A$10) with our holidays for the year (7/4/23, 9/4/23,...)
I need a conditional format that changes the background of cells in column B if the value of the cell in column A on that row is 5 business days older than today().
The combination of Holidays and NETWORKDAYS and >5 days is confusing me.

 

[Tetra201]

Try

=AND($A1<>"",NETWORKDAYS($A1,TODAY(),Holidays)>5)

 

[SandsB]

=AND($A1<>"",NETWORKDAYS($A1,TODAY(),Holidays)>5)

I don't get any formatting change when I do this. Not sure why.

 

[SandsB]

I don't get any formatting change when I do this. Not sure why.

If I point to the cells with the holiday, this works great - thanks Tetra201. Pointing to the named range does not.
If I look at Name Manager, Holidays point to the same cells so I'm not clear where my problem is.

 

[Joe4]

Is "Holidays" the name of your sheet or named range, or both?
If both, I would recommend using a different name for your named range.

 

[SandsB]

Is "Holidays" the name of your sheet or named range, or both?
If both, I would recommend using a different name for your named range.

Jut the named range. I still haven't figured this one out but pointing to the cells works. Strange because I do the same thing in another sheet and it works fine.