Conditional Format to Highlight Row Where Date in Column Within 5 Business Days of Range

Originally Posted by Root_

See if the following CF rule works for you:

=ABS(NETWORKDAYS(F22,B22,Holidays))<=5

where Holidays is a named range that contains holiday dates.

I found the issue. So I need B22 to refer to a named range, as opposed to a value in an adjacent column, is that possible?