Copying Conditional Formatting

[Guest]

Hello-

I have 2 columns. I would like to highlight the cells in column B when not
equal to the corresponding cell in column A.

I have setup the condition like this:
Cell Value is Not equal to =$M$2 and then set the color

My problem is I can't seem to copy this to the other cells in the column
correctly. It seems simple, but I'm obvioulsy doing something wrong.

Or,

Should I be using the Formula Is? I don't know how to indicate if cell
B2<>A2, if B3<>A3 etc...

Thanks in advance for your help!

 

[Guest]

You can do it for the entire col at one go

Try this
Select col B
Click Format > Conditional Formatting
Under Condition 1, make the settings as:
Formula is: =B1<>A1
Format to taste, ok out

 

[Guest]

Got it. The cell value can not be =$M$2, but =M2
Sorry to waste cpu time on this.
Still and ever learning...