Highlighting Cells when equal to each other

[n18]

Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have 2 columns in my excel sheet, what I want to do is that if they are equal to each other to highlight them green and if they are not equal to each other to highlight them red, there will also be blank cells, where there is blank cells in either row I don't want to highlight them, for example my sheet looks something like this

ID1 ID2
2
3 3
3 4
5

Can you do this using conditional formatting or is it better to write a simple Macro?

Thanks

 

[JamesW]

Hi,

Conditional Formatting will do this for you:

Cell Value Is: equal to,, =A2 - Green
Cell Value Is: not equal to,, =A2 - Red

 

[n18]

Thanks James, how would I apply this to all the rows in my sheet? I have a few thousand, there will be blank rows in between also. If I try and drag the formula from cell to cell it will point back to cell B2 in this case, Is it possible to apply the conditional formatting rules to the entire column and not specific cells?

Thanks again

 

[JamesW]

hi,

Highlight the whole column and change to =A1 (without $ signs).