+ Reply to Thread
Results 1 to 4 of 4

adjacent cell conditional formatting

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    adjacent cell conditional formatting

    Hey all this should be an easy one, but my brain isn't working today.

    So I have two columns of data: columns A and B

    I want to have conditional formatting highlight cells in column B that are not an exact match of the adjacent value in column A.

    So A2 = 13109 and B2 = 13109. it's a match, so don't format it
    but A3 = 2500000 and B3 = 0. Since there is a discrepancy I want this highlighted (and I want the highlight to show up in the B column). I guess it could also work to have both cells be formatted where there is a discrepancy if that's easier.

    What worked for me originally was to highlight A2:B2 and apply conditional formatting for unique values, but then I would have to do it manually for A3:B3, and A4:B4, one pair of cells at a time.

    I know there is a better way, but I just can't figure it out at the moment.

    thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,041

    Re: adjacent cell conditional formatting

    Select B2

    Conditional Formatting
    New Rule
    Use a formula to determine. . .

    =(A2<>B2)
    format as required

    Use Format painter to copy to other cells.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,021

    Re: adjacent cell conditional formatting

    Click on B2.
    CF: Use a formula. Formula is: =A2=B2. Format as desired. Copy format to the rest of col B. using format paintert.
    Pete

  4. #4
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    Re: adjacent cell conditional formatting

    Solved! Works great! Thanks for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting based on text in adjacent cell
    By lauralaura in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-16-2014, 05:16 PM
  2. Conditional formatting on adjacent cell
    By branred in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2013, 03:40 AM
  3. Conditional Formatting based on Adjacent Cell
    By MacroPolo in forum Excel General
    Replies: 3
    Last Post: 06-23-2012, 01:41 AM
  4. Conditional Formatting Based on Adjacent Cell
    By Yourgurlwantsme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2010, 05:31 PM
  5. Replies: 2
    Last Post: 01-10-2005, 06:06 PM

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