Results 1 to 4 of 4

Highlighting Duplicate cells?

Threaded View

  1. #1
    Registered User
    Join Date
    03-20-2017
    Location
    Mauritius
    MS-Off Ver
    2016
    Posts
    2

    Highlighting Duplicate cells?

    Sorry!
    I deleted the post that was here by accident. But here is the form again:

    FORM1
    NAME |LEVEL| PRICE
    EXAMPLE 1 B £1
    John 2 S £1
    XXXX G £1
    EXAMPLE 2 B £1
    EXAMPLE 1 B £1
    Metal 3 D £1
    Metal 4 S £1

    Basically, it should be something like > if level =B and name has a duplicate , then highlight in red. Once i figure this one out, i want to do it for other levels. for example, a name with Level S can only be written twice. and there are other levels too.
    Last edited by Rexx372; 03-20-2017 at 05:14 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-17-2014, 05:44 PM
  2. Highlighting Duplicate Cells
    By vinceancona in forum Excel General
    Replies: 5
    Last Post: 09-28-2013, 02:22 PM
  3. [SOLVED] Highlighting Duplicate Cells
    By paodelol in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-11-2013, 11:15 AM
  4. Replies: 0
    Last Post: 02-05-2013, 07:51 AM
  5. Finding duplicate cells and highlighting them
    By masond3 in forum Excel General
    Replies: 5
    Last Post: 08-07-2012, 08:35 AM
  6. highlighting duplicate cells
    By langdon37 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2009, 05:58 AM
  7. How to Highlighting duplicate ALL cells on A:A column with red ?
    By yannipr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-19-2008, 04:08 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