Conditional formatting of adjacent cells based on text in cell

[elderain]

Hello,

I have an excel sheet that is updated daily from reports in business
objects. There are 2 coumns, both have an address in them, similar to
below:

100 LEVALL BLVD 100 LEVALL BLVD
100 NORTH ROCKWELL SUITE 108 100 NORTH ROCKWELL
100 W GENESEE STREET 100 W GENESEE STREET
10100 DIXIE HWY 10100 DIXIE HWY

I am looking to make a conditional format that says if the text in
column A, doesnt match column B, turn it red, if it does match, turn it
green. 99% of the time, both cells should be identicle, if the person
didn't mess up. We are looking to spot quickly any errors (what would
show up in red) instead of spending hours looking manually if there are
differences.

As seen above, rows 1,3, and 4 are good, they match exactly, where as 2
does not, and would need to show up in red to alert us we need to make
a change. I cant seem to get this to work, can someone offer some
assistance?

-Josh

 

[daddylonglegs]

Select column A and use conditional formatting formula is option with
formula

=A1<>B1

note this isn't case sensitive. If you want it to be

=NOT(EXACT(A1,B1))