To always compare to C4 and C5 for all cells use this

C7<$C$4 - Yellow
C7<$C$5 - Red

The reference percentages in C4 and C5 must be absolute references, not relative references. If your rule says

C7<C4

it will compare every cell to the one three rows higher, not to C4.