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!

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DTTODGG" wrote:
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!

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

"DTTODGG" wrote:

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!