+ Reply to Thread
Results 1 to 2 of 2

highlight a cell in a column if value is unique from another column please

  1. #1
    Registered User
    Join Date
    10-15-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    37

    highlight a cell in a column if value is unique from another column please

    Hi can anyone tell me if there is a way to highlight or expose a cell in a column (B:B sheet1) if the value it contains does not appear in another column (A:A sheet 2) please?

    my two columns are actually on different sheets if this makes a difference.

    many thanks

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: highlight a cell in a column if value is unique from another column please

    You could highlight all of the cells the color you want it to show when no duplicates appear, then use Conditional Formatting to highlight duplicates and have them show up as White with Black Text.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

+ 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. Replies: 4
    Last Post: 10-09-2015, 05:19 AM
  2. Highlight cell in column when compared to each value of another column
    By Adamahl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-25-2014, 09:52 AM
  3. Replies: 12
    Last Post: 04-11-2014, 07:18 PM
  4. Find 1st unique Value on Column and Insert certain Word on cell on left Column
    By Wldlife23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2013, 10:02 AM
  5. How to highlight cell on column A if they include any of the strings on column B?
    By sami770 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-22-2013, 09:30 AM
  6. Highlight column once unique ID found
    By Hnedjari in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2012, 12:20 PM
  7. Highlight empty cell in column C once column A in same row has date entered
    By glyndennett in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2011, 11:16 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