Conditional Formatting for Dates from Today

More conditional formatting, but hopefully this is pretty simple.

I would like to add the following conditions to column C, for which I have named the range/column DATERECEIVED. I would like to use that name in my formula.

Dates in the DATERECEVIED column (C) that are equal to or less than 12 days and equal to or less than 26 days from TODAY should be highlighted in yellow.
Dates in the DATERECEIVED column (C) that are equal to or greater than 27 days from TODAY should be highlighted in red.

The calculation should exclude weekends and HOLIDAYS when counting the number of days. Because the HOLIDAYS for the company are unique, the list of them is in the worksheet HOLIDAYS.
The formatting should highlight only cells with dates and leave cells that contain either blanks or TBD with no formatting.

Attached is a sample spreadsheet.

Thank you

Is this not a similar requirement to ..

https://www.excelforum.com/excel-for...ml#post4912044

???

It is similar but not the same unfortunately.

When I used the formulas in the other sample spreadsheet, altering them of course, the highlighting did no t take. I am also having some serious performance issues with the spreadsheet. I am trying to change the formulas to named ranges, but even doing this is taking forever.

Ok - that worked - thank you again
Also, changing the holidays range helped immensely in spreadsheet performance. It is amazing that it could bog down the spreadsheet as much as it did.

Thank you for all of your great help!