Copy Conditional Formatting

[Ozgur Bilgin]

I used conditional formatting property for one row such that if $M$2="X" then
apply formatting to $A$2:$O$2. That formatting rule works.

Now I want to apply that formatting to all rows such that if $M$3="X" then
apply the same formatting to =$A$3:$O$3 and if $M$4="X" then apply the same
formatting to =$A$4:$O$4 and so on. How can I copy the formatting to all
sheet as I explained above.

Regards,
Ozgur...

 

[Luke M]

Get rid of absolute reference on row number, e.g.:

Formula is:
=$M3="X"
Apply this to row A3:O3, then you can copy down as desired.