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