Results 1 to 5 of 5

Trying to highlight consecutive duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2020
    Location
    FL
    MS-Off Ver
    H&B 2016
    Posts
    14

    Trying to highlight consecutive duplicates

    Hello. I have a workbook in which I want to highlight consecutive duplicate values within a specific column. Using the canned conditional format option for highlighting duplicates highlights all values that appear in the column more than once and I only want duplicates that are consecutively listed highlighted. I found many websites that say setting a CF rule using the formula =or($A1=$a2,$A2=$A3) would work and many even show screenshots of it working. For me it does not work. Using that logically results in the cell just prior to a group of duplicates getting highlighted and the last cell in a each group of duplicates not getting highlighted. It also highlights the last cell which I do not fully understand. It highlights blank cells at the end which I can clear up with another CF rule once I get the primary one worked out.

    Please help as I feel like this approach is only not working for me, but it makes sense to my why it is not working. I am also open to a completely different approach, ideally one that I can apply through a CF.

    I have attached a basic example of of what the current result is and what I would like the result to be.

    Thanks

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to Highlight consecutive repeated values > 3 in a row??
    By pabeader in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2020, 12:40 PM
  2. [SOLVED] Remove consecutive duplicates
    By Round_Sphere in forum Excel General
    Replies: 9
    Last Post: 11-12-2018, 10:05 AM
  3. Highlight consecutive rows based on value
    By olgratefuldead in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2017, 05:54 AM
  4. Highlight the 2nd lowest value of a non-consecutive range
    By Shareez Saleem in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 07-27-2016, 06:47 AM
  5. Highlight Consecutive Duplicates
    By cjay123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2015, 10:00 PM
  6. Highlight consecutive numbers in array
    By ricklou in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2013, 05:39 AM
  7. Macro to check for duplicates and highlight duplicates
    By obc1126 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2008, 09:55 PM

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