Results 1 to 15 of 15

Using Exact function to color cells that do not match.

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    38

    Using Exact function to color cells that do not match.

    Good morning,

    I have a spread sheet which easily could go to 300 lines of information. It used data from two different systems and compares them.

    Using Conditional Formatting I can determine which piece from each system does not match (in the sample it is column B and column I). This only works to a degree. As you can see in the sample B4 and B5 match so no formatting takes place.

    The comparison should really lie between B and I and not within each column. The only way I can think of doing this is to run the Exact function. And this works...obviously.

    However, I want it to be readily visible to the user. I would like to format the cells in B and I that do not match making them stand out rather than searching through the text created by the function.

    I am thinking it may be a nested formula?

    Anyways...I would appreciate any help I can get.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Regex exact match function
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 05-03-2019, 02:40 AM
  2. Validating 2 cells goes wrong, finds first match instead of exact match.
    By EricNL in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2015, 08:38 AM
  3. [SOLVED] Found function with exact match
    By bimo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2014, 04:27 AM
  4. FIND function exact match
    By kgolding in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 12-13-2013, 10:41 AM
  5. Replies: 3
    Last Post: 06-17-2013, 12:37 PM
  6. [SOLVED] Exact Value match in Lookup function
    By cdjindia in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-28-2012, 08:48 AM
  7. Font color of exact function return in excel should be customize
    By Thakku Ramanan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2005, 02:55 AM

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