I need a CF formula that compares each date in row 3 to the vertical holiday list on worksheet 'Holidays' and colors the cell(s) in row 3 when there is a match for the same WEEKNUM(nn,2) in range 'Holidays'$D$5:$D$40. The expected quantity of CF-colored dates should equal the 3-year range of the Holiday list...
Attempted CF formula =WEEKNUM(L$3,2)=MATCH(WEEK
,1)... but this does not work correctly. Trying CF TEXT() formulas limits to only 3 correct 'hits' and only if using single-digit values in a series 1 to nn beneath the date series
sample workbook attached has layout and several attempts with CF formulas