Header doesn't show conditional formatting

Tried to look this up but this specific issue was not addressed yet.

I have a table as shown in the first picture. Top left corner address is C7. Top row is not part of the table and is plain without any formatting, dark brown row is a header row for the table.
I made two conditional formats, other formula based on C7 value, other on C8 value as shown in the second picture.

Blue cells are result of conditional formatting for C7.
Capture.PNG

Formulas
captuer2.PNG

For an unknown reason the conditional formatting doesn't work with the cell C8 which is in the header row. Why is that, and how can I get it to work?


Cheers!

EDIT: I just realized how misleading the headline is, apologies!!
The problem simply is: When using HEADER cell C8 in the CF rule ($C$8=1), conditional formatting doesn't work. In this case cells D10:D12 should turn to RED as the cell contains value 1.
I tried this with another empty workbook and CF works fine without headers, but as soon as a table with headers is introduced, all CFs will disappear if the rule is based on header cell.

Please attach the workbook, not a picture of it.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Your range that you applying CF to, only starts in 10. try extending the ranges

Doh!!! I should have gone to Specsavers ...

See post #2. Without seeing the workbook, there is not a lot any of us can do.

Oh I was wondering if it's my computer or something blocking the attachment link. I created a new workbook that has exactly the same setup with explanations. Hopefully that works.

Headers in a table are always text (you can see that they are left-aligned), so you will need this:

=--I$1=DAY(TODAY())

The double unary (--) forces the formula to see the text as a value.

It works!! I could never have figured that out, neither those 20+ google top search results did. Thanks

It's only when I saw the left-aligned cells in your attachment that I remembered about table headers being text - run into it myself in the past using dates as table headers!

Glad to have helped!