I have a list of vaules in column A and column B. I need to highlight where there is a difference between values that are in the same row.

I've used a simpe formula in B1: $A1<>$B1 (format bold). It works (values are different), but now I would like to copy and paste special this format to all the values in column B, so that it refers to it's neighbour in column A.

I.e. A1<>B1; A2<>B2, etc down to row 100.

Problem is the formula keeps using the original reference. Therefore everything is bold. Surely I dont need to copy and paste the CF to each individual value in column B (please no!)

I know I'm missing a step. Please let me know what it is.