+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting of adjacent cells based on text in cell

  1. #1
    elderain@gmail.com
    Guest

    Conditional formatting of adjacent cells based on text in cell

    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


  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    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))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1