Results 1 to 2 of 2

Conditional Formatting to display Unique Values across Multiple Columns

Threaded View

  1. #1
    Registered User
    Join Date
    04-15-2016
    Location
    Philadelphia, PA
    MS-Off Ver
    2010
    Posts
    1

    Conditional Formatting to display Unique Values across Multiple Columns

    I have 4 columns that should all be the same date. I need assistance in the conditional formula rule that would highlight the cell between columns $I:$L that does not equal the value in $H.

    So for example, in row 4 - cell H4 would be the default, if J4 and L4 do not match, each of those should be filled with a color. If I5:L5 all don't match H5, then all would be colored, if they all matched H5 then none would be.

    Thank you in advance!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional formatting duplicate values in multiple columns
    By PowerZ in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 01-08-2016, 08:04 AM
  2. Replies: 0
    Last Post: 02-25-2015, 10:27 AM
  3. Aconcat to display multiple unique only values in cell
    By zappyzoo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-05-2015, 10:41 AM
  4. [SOLVED] Conditional Formatting Rows based on Unique Values in Column
    By drjones5 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-13-2013, 04:27 PM
  5. Conditional Formatting for Unique IDs in Columns
    By mycon73 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 08-24-2011, 05:45 PM
  6. Replies: 5
    Last Post: 04-21-2011, 05:22 PM
  7. conditional formatting to find non-unique values
    By CrystalNewb in forum Excel General
    Replies: 9
    Last Post: 12-14-2009, 05:24 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