+ Reply to Thread
Results 1 to 2 of 2

Highlight row if values if columns x and x+1 match.

  1. #1
    Registered User
    Join Date
    12-11-2020
    Location
    USA
    MS-Off Ver
    latest?
    Posts
    1

    Highlight row if values if columns x and x+1 match.

    Helo and thank you for your time. I am trying to highlight rows when the value in a column match AND are next to each other. Sample files attached with the desired result . Basically like this,

    Blue
    Orange
    Green
    Green

    Orange
    Grey
    Blue
    Orange
    Orange

    Silver
    Black
    Blue

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Highlight row if values if columns x and x+1 match.

    Your sample is not the same as what your title or description say so I am going to go with your list.

    You need two conditional formatting rules. Let's say your data is in column A.

    Applies to A:A
    =A1=A2

    Applies to A2:A?? where ?? is the highest possible row number you expect to use
    =A1=A2

+ 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. [SOLVED] highlight cells when tab values match
    By Azuczek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2019, 11:49 PM
  2. Compare two columns and highlight cells with same values (Considering one-to-one match)
    By jahanzaib447 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-03-2019, 11:11 PM
  3. [SOLVED] Find partial match between two columns and highlight cells that match
    By TomToms in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-18-2019, 01:07 PM
  4. Compare duplicate values in two columns and highlight if match
    By JEKF in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-18-2015, 12:32 PM
  5. [SOLVED] Highlight match old and new SKU from two columns and change price
    By juno612 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-20-2014, 06:42 PM
  6. [SOLVED] Highlight cells if data in 2 columns match
    By damobilebrood in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-28-2014, 09:19 AM
  7. Match data in 2 Worksheets and highlight columns
    By JimmiOO in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2010, 08:47 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