Share via

how to highlight duplicate values on the same row?

Anonymous
2015-08-31T16:39:32+00:00

Hello,

Does anyone knows how to highlight duplicate values on the same row?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2015-09-01T11:24:40+00:00
    1. Select your range. Let's assume that your range is A3:E10.

    2. Home tab > Conditional Formatting > New Rule > Use a formula to determine which cells to format and put following formula and choose appropriate Fill Colour

    =COUNTIF($A3:$E3,A3)>1

    (Note the formula is dependent upon the your starting cell in the range. If A3 is not the starting cell, then you will need to replace $A3 and A3 appropriately)

    8 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2015-08-31T16:44:59+00:00
    1. Select the Row
    2. Home tab > Conditional Formatting > Highlight Cell Rules > Duplicate Values

    3 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-08-31T17:23:26+00:00

    I have over 60 thousand rows and between 2 to12 columns, Conditional Formatting takes in consideration other columns instead of just individual rows. Any help is appreciated!!!

    4 people found this answer helpful.
    0 comments