Conditional formatting not reacting

Hello friends,

Please open the attachment, I made a macro that works fine, it basically copies row/range 14 and pastes to 15,16 etc. there is no problem here.

The conditional formatting is driving me crazy. It is not working! I need two things please:
A. If one of the cells in the range G14 to AK14 = cell C14, then that box should be in red.
B. Also the rows 15 and beyond should do the same depending on the value (date) on column C.
With B, every time I copy&paste ranges G14 to AK14 and paste them onto row 15 (16, 17, etc), the cell value of the rule description stays at C14, when it should change with the new pasted row number.

Your generous efforts are really appreciated!

Thanks in advance.

Change to =$C14 as Bernie Said.

B) Instead of copy pasting the formats.
Just make the format apply to the whole range in the first place by changing the Applies To Range to encompass all rows
=$G$14:$AK$16

The rule will still refelect the original Row 14.
The rule formula is displayed relative to the top/left cell of the Applies to range.
So with =$G$14:$AK$16 as the applies to range, then the formula is displayed relative to G14.
But rest assured, the row#s incriment just fine according to the rules you apply with the $'s