Results 1 to 7 of 7

Highlight duplicate numbers in rows and coloumns from a different range.

Threaded View

  1. #1
    Registered User
    Join Date
    06-20-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    4

    Smile Highlight duplicate numbers in rows and coloumns from a different range.

    Hi,
    I shall try to explain this properly.

    I have numbers in the range D8 thru I13. (1)
    I have numbers in the range D1 thru I5. (2)

    Now, what i want to do is have any numbers in range 1 that are also in range 2 highlight themselves. But the highlighting is only to be in range 1, and also, if there are any blank cells the highlighting should not happen. The duplicates that need to be counted are only entered numbers and not blanks.

    I have tried to attach an example of the spreadsheet. Hopefully that will help.

    Many thanks, in hope.
    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