Results 1 to 3 of 3

Highlight cells that are common among several columns

Threaded View

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    NYC, US
    MS-Off Ver
    Excel 2007
    Posts
    2

    Highlight cells that are common among several columns

    Hi all,

    I am trying to highlight cells that are common among several columns i.e. values that are not just duplicates but have to be present in all the columns. I have attached an example showing what I am looking for -

    32 3 211 45
    3 45 3 32
    45 21 32 1
    76 32 9 9
    101 17 45 7


    In this example, only 32 and 45 are present in all the 4 columns and they have to be highlighted. Any help would be appreciated. Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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