When you copy this across the row it will apply the formatting rule but each one will only change when the top cell is set to actual (the formula changes from =C$3 to =D$3, =E$3 automatically).
You could use the format painter and select the whole range to applay formatting to all the cells in one go for quickness but it you do that gap rows you have will end up changing colour too.
Bookmarks