+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting to display Unique Values across Multiple Columns

  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

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Conditional Formatting to display Unique Values across Multiple Columns

    you could use

    =AND(J4=$H4, L4=$H4 )

    confused on if we are comparing I and J and K and L - with H
    or if you are checking different columns on different rows

    OR you could just use
    =$H4=I4 and apply to I4:L100
    or what ever row you want
    and then the cell that does not match will highlight

    Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
    We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

    To attach a file to your post,
    click "Go advanced" (next to quick post),
    scroll down until you see "manage Attachments",
    click that and select "Choose File" (top Left corner).
    Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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] 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