+ Reply to Thread
Results 1 to 3 of 3

Conditional Format formula does not correctly FILL adjacent cells when values not equal

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Panama City, FL
    MS-Off Ver
    Excel 2016
    Posts
    175

    Conditional Format formula does not correctly FILL adjacent cells when values not equal

    Hellos Excel friends,

    I have searched and not found this particular type of question in the archives. Hopefully it's simple and I just cannot see it.
    I merely want to highlight two adjacent cells when the values in the adjacent cells are not equal.
    I used the following formula:
    Please Login or Register  to view this content.
    I reduce each one (see: -1, -2) to exclude the space in column A, and to exclude the trailing comma and the space in column B.

    Thanks for any assistance provided!
    *I have attached a sample spreadsheet.
    Attached Files Attached Files

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,444

    Re: Conditional Format formula does not correctly FILL adjacent cells when values not equa

    Apply the following CF to A2:B4 =LEFT($A2,FIND(" ",$A2)-1)<>LEFT($B2,FIND(" ",$B2)-2)

    Be careful with your cell referencing...

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Panama City, FL
    MS-Off Ver
    Excel 2016
    Posts
    175

    Re: Conditional Format formula does not correctly FILL adjacent cells when values not equa

    Thank you very much Pepe Le Mokko, works like a charm.

+ 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 format equal, adjacent cells
    By Emma Eve in forum Excel General
    Replies: 6
    Last Post: 02-21-2019, 01:26 PM
  2. Conditional Format around 0 (+adjacent cells)
    By Median in forum Excel General
    Replies: 2
    Last Post: 03-30-2018, 03:44 PM
  3. [SOLVED] Conditional format when adjacent cell values match
    By penn01 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-30-2015, 10:13 AM
  4. [SOLVED] SUM cells with equal values in an adjacent column.
    By angelopc in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-13-2013, 09:55 AM
  5. [SOLVED] Search Function used to fill in Values of adjacent cells
    By BrettW in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-14-2013, 04:30 PM
  6. auto merge adjacent cells into one if cell values are equal
    By egosselin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2012, 12:24 AM
  7. Conditional Format-cells with un-equal numbers
    By AWS in forum Excel General
    Replies: 4
    Last Post: 09-27-2005, 06:05 PM

Tags for this Thread

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