Results 1 to 11 of 11

Highlight Rows of Duplicate results column with unique coloring

Threaded View

G-Co Highlight Rows of Duplicate... 07-20-2017, 02:30 PM
danielexcelvba Re: Highlight Rows of... 07-20-2017, 03:24 PM
danielexcelvba Re: Highlight Rows of... 07-20-2017, 05:02 PM
G-Co Re: Highlight Rows of... 07-20-2017, 06:26 PM
G-Co Re: Highlight Rows of... 07-20-2017, 06:39 PM
scottiex Re: Highlight Rows of... 07-20-2017, 07:06 PM
G-Co Re: Highlight Rows of... 07-21-2017, 02:17 PM
scottiex Re: Highlight Rows of... 07-23-2017, 04:59 PM
G-Co Re: Highlight Rows of... 07-24-2017, 12:59 PM
scottiex Re: Highlight Rows of... 07-24-2017, 05:51 PM
G-Co Re: Highlight Rows of... 07-24-2017, 07:09 PM
  1. #1
    Registered User
    Join Date
    07-20-2017
    Location
    Canada
    MS-Off Ver
    13
    Posts
    6

    Question Highlight Rows of Duplicate results column with unique coloring

    Hello,
    I have searched and tried various Macros but none are working for me - appreciate your help.

    My spreadsheet is A1:G1289 with Row 1 being header.
    Column F contains duplicate part numbers

    Objective: Identify duplicate values in column F (Any value in column F that is equal to another value in column F) and highlight those ROWS (groupings) with unique coloring.
    This spreadsheet will continue to grow so would like the maximum color spectrum available.

    Thanks in advance.
    Glen

    Excel 2013
    Last edited by G-Co; 07-20-2017 at 06:43 PM. Reason: Clarifying and correcting details

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight duplicate two column and two column unique value
    By mahmudayaz in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 01-26-2017, 02:58 AM
  2. [SOLVED] Highlight duplicate rows excluding column and vice versa another column
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-07-2016, 02:22 PM
  3. highlight duplicate rows and delete based on highest value from column
    By adnan5586 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2015, 02:05 AM
  4. [SOLVED] Need a macro to highlight Rows that contain a duplicate for each column of a data range
    By MoHassan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-22-2013, 05:39 AM
  5. Highlight duplicate rows based on column A but be case sensitive
    By theblade24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2013, 06:14 PM
  6. Highlight duplicate rows without helper column
    By tone640 in forum Excel General
    Replies: 5
    Last Post: 08-23-2011, 08:21 AM
  7. Replies: 0
    Last Post: 07-22-2011, 12:11 PM

Tags for this Thread

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