Apply conditional formatting to multiple cells merged on a row from a data merged row

Hello,

This is my first post here, just registered
I'm seeking your help for the following problem:

I'm struggling with conditional formatting. In normal situations it's alright, but for aesthetic purposes some cells (one from which I take data to know whether or not to apply the formatting, and others to which I wish to apply said formatting) are merged and span multiple columns (i.e. they are merged on the row/horizontally).

What I'm trying to do is highlight all the cells that correspond to the current date.
Right now, June 12th, I can see the 12th of every month highlighted for the metrics that contain unique cells. (whereas I'd like only the 12th of the current month - i.e. the current date - to be highlighted)
Moreover, this highlighting seemingly doesn't work on the metrics that contain merged cells that span over 2 weeks or over the whole month.

From my very limited understanding something like this should at least solve the first problem:
IF(AND(C$1=TEXT(TODAY(),"MMMM"),C$3=NUMBERVALUE(TEXT(TODAY(), "dd"))), TRUE, FALSE)
except it doesn't work (I suspect because of merged cells).


Please see enclosed excel sheet to get a better idea of what I'm talking about

Thanks in advance for your help!