View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DTTODGG DTTODGG is offline
external usenet poster
 
Posts: 74
Default Copying Conditional Formatting

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!