Conditional Formatting question

[tracer2062]

I’m using Excel 2007. What I'm trying to do is compare two columns of numbers, and if the adjacent cell is different highlight it. The problem I have is that I do not want to go to each individual cell and do conditional formatting. I want to know how I can do this for the entire column. Thank you for the help. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>

 

[VoG]

Select the whole column of values, Conditional Formatting, New Rule, Use a Formula.. then use a formula like

=A1<>B1


Excel will automatically adjust the row numbers for rows further down.

 

[RoryA]

Let's say you are comparing A2:A100 with B2:B100 and you want to highlight B.

Select B2:B100. Click Conditional Formatting on the Home tab, choose New rule... and choose Use a formula to determine which cells to format...
In the formula box enter:
=B2<>A2

and choose the formatting you want, then OK out of the dialogs.

 

[Norie]

Select the relevant cells in both columns, goto Conditional formatting, enter this formula:

=$A1<>$B1

and format as required.

That should highlight both cells if they are different.

 

[tracer2062]

How do I prevent it from highlighting the entire column? I just want it to highlight the individual cell in the column if it's not equal to the other cell in the column.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>

 

[VoG]

Did you try what we suggested?