+ Reply to Thread
Results 1 to 2 of 2

Highlight Duplicate (numerical) values that are next to each other

  1. #1
    Registered User
    Join Date
    11-18-2020
    Location
    New York, New York
    MS-Off Ver
    Office 16
    Posts
    1

    Highlight Duplicate (numerical) values that are next to each other

    Hi,

    I have a list of monthly returns (columns for Jan, Feb, Mar...) for a list of investments (in rows). I need to highlight instances where return values are identical for consecutive months (i.e. a single investment's returns are the same in Apr and May). I am having trouble figuring out how to do this separately for each investment.

    In the attachment, D1 & E1 should be highlighted, D7-F7 should be highlighted, among others.

    What is the formula for this?
    Thank you,
    Attached Files Attached Files

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Highlight Duplicate (numerical) values that are next to each other

    CF formula in B1:

    =AND(B1=A1,B1<>"")

    apply to whole range
    Attached Files Attached Files
    Quang PT

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight or display duplicate rows not duplicate values
    By olga6542 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2019, 03:24 PM
  2. [SOLVED] highlight duplicate values in their own row even if values aren't adjacent
    By terryhenderson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2016, 01:20 PM
  3. Conditional Formatting of Duplicate of numerical values With Tolerance
    By CBerisso in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2015, 08:36 PM
  4. Need a Formula to Detect Duplicate Numerical Entries and Highlight Them
    By jsw1984 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-12-2014, 01:10 AM
  5. Highlight duplicate values
    By abibayley in forum Excel General
    Replies: 3
    Last Post: 04-23-2012, 12:03 PM
  6. Need help on how to highlight duplicate values
    By avadakedava in forum Excel General
    Replies: 3
    Last Post: 04-10-2012, 11:27 AM
  7. Highlight duplicate row values
    By Brian Tam in forum Excel General
    Replies: 5
    Last Post: 08-27-2010, 04:54 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