+ Reply to Thread
Results 1 to 5 of 5

Find Mismatched Cell Values

  1. #1
    Registered User
    Join Date
    07-11-2014
    Location
    Washington
    MS-Off Ver
    unsure
    Posts
    7

    Find Mismatched Cell Values

    I am trying to identify cells within a row that have a different value from the second cell in the row. (The first cell in the row represents the identifier) All the cells within the row should either have a blank (if there was no value linked to the identifier) or a set of RGB values separated by commas. I have tried a variety of MATCH, EXACT, Special - duplicate rows, type formulas but either the commas within the cells or the blanks are messing with the formulas. Please let me know if I need to clarify more. I have attached an example of my spreadsheet. (As you can see in row 2, J2 and K2 are different from B2, so ideally I would like these cells to be highlighted to point out the difference). Thank you in advance to whoever can help.
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Find Mismatched Cell Values

    Suggest using conditional formatting

    Formula =NOT(C2=$B2)

    Applies to =C2:L19
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,628

    Re: Find Mismatched Cell Values

    Try this if you don't want to highlight blank cell in the range C2:L19, otherwise mrice's formula will do the trick by simply using
    Please Login or Register  to view this content.
    Select C2:L19 --> Conditional Formatting --> New Rule --> Use a formula to determine which cells to format --> In the formula box below "Format values where this formula is true", paste the formula given below --> Format --> Fill --> Choose the color of your choice --> OK --> OK.

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Registered User
    Join Date
    07-11-2014
    Location
    Washington
    MS-Off Ver
    unsure
    Posts
    7

    Re: Find Mismatched Cell Values

    Thank you so much!!! This did the trick. I was about reply asking how to exclude blanks and sktneer solved that for me.This has really helped! Just a note for anyone who may read this later, the first time I applied the conditioning I accidently included column B in my range (B2:L19 instead of C2:L19) and it gave a partial output of what I wanted and I couldn't figure out why it wasn't working. So that was a easy fix once I realized what I had done.

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,628

    Re: Find Mismatched Cell Values

    Glad I could help.
    If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
    Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

+ 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. [SOLVED] wheres my type mismatched??
    By bdrilling33 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-10-2014, 08:30 AM
  2. [SOLVED] Match Two MisMatched Reports and Find Variance
    By qualk23 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2013, 11:54 AM
  3. [SOLVED] Finding Mismatched Months
    By Tim Kennedy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-03-2013, 09:48 AM
  4. using rows of mismatched values across sheets
    By jslesser in forum Excel General
    Replies: 9
    Last Post: 11-27-2011, 03:50 PM
  5. How Do I Find Mismatched Data?
    By Ocean Zhang in forum Excel General
    Replies: 2
    Last Post: 11-05-2010, 02:17 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