conditional formating - dragging a cond. format over an entire col

[Guest]

OK, I have 3 columns I am working with, I set up a conditional formula where
C1 > B1 OR C1 > A1 then turn C1 red font. I want to "somehow" drag this
conditional format down the entire C column and have it automatically adjust
to the rows, for example , like this; C2 > B2 OR C2 > A2, C3 > B3 OR C3 > A3
, etc. Kind of like when you enter a formula in a spreadsheet, then drag
the formula over an entire column, and it adjusts accordingly. I tried using
the format painter, but this does not work, it just applies the first formula
to every cell in that column.. Any suggestions would be great!, Thanks

A B C
7 6 5
4 5 6
8 4 7

 

[Guest]

get rid of the "$" in the conditional formatting

 

[Guest]

thanks, worked perfectly

get rid of the "$" in the conditional formatting

 

[Artem]

Hi, I have a similar problem and this answer
should have worked out for me as well. Exept for
I dont have any "$" in my formula. When I use
Format Painter it applies the same formula as at first
row to the rows below. Any ideas ? Thanks in advance