Hey there
I have seen this forum and was very happy as I have an issue with excel 2010 that i couldn't solve.
I wrote a condition which works perfectly for one row and would like be able to copy it for the remaining 200 rows. But it doesn't work.

I want to do the following for each line
if the cell in row c contains "1", "2", or "3" then the color of rows G to H should change (to blue) that the users sees that he should not forget entries in those rows.
The rule description i have done in the conditional formatting rules manager is the following:
=OR($C24="1"; $C24="2";$C24="3")

The formula works fine (for row 24) but I would have to adapt it to every line therefore I tried just to copy it down. And there it gets strange to me: all lines meeting the condition get blue (what is good) but if I change after copying a cell in row C t(e.g. from "1" to "500") then the blue color remains and does not flip back to the original color (what I would like)

Is there another way which is copyable for the other lines in the conditional formatting? Or do I have to go for VBA? How would this then look like?

I would be very happy if somebody would accept the challenge to help me