Highlight Duplicate Rows based on Value on 2 different Columns

**sunil31** · 09-21-2019, 03:45 AM

Hi,

I have a more than 30000 rows in Sheet 1 and more than 1000 rows in Sheet 2. In Sheet 1, "Tracking ID" column I have some values and same values are in other sheet Say Sheet 2. I want to highlight all the rows in Sheet 1 based on values given in Sheet 2. Values given in Sheet 2 are duplicate of Sheet 1 values. I have attached sample Excel file for the reference.

For example, in Sheet 2, if value is OD515 and it is found in Sheet 1 then that row should be highlighted.

If this type of question is already asked, please redirect me to that link.

Thanks,

Suunil

**maras_mak** · 09-21-2019, 04:28 AM

Use Conditional Formatting.
1. Select all data in column D of sheet1.
2. Home > Conditional Formatting > New Rule.
3. In the New Formatting Rule dialog box, Use a formula to determine which cells to format.
4. Type the formula: =COUNTIF(Sheet2!$A$2:$A$1000,$D2)
5, Click Format --> Fill tab --> select yellow.
6. Click OK.

**beepetark** · 09-21-2019, 04:56 AM

formula in conditional format

=ISNUMBER(MATCH(D2,Sheet2!$A$2:$A$10,0))

Highlight Duplicate Rows based on Value on 2 different Columns

LinkBack

Thread Tools

Rate This Thread

Display

Highlight Duplicate Rows based on Value on 2 different Columns

Re: Highlight Duplicate Rows based on Value on 2 different Columns

Re: Highlight Duplicate Rows based on Value on 2 different Columns

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need to highlight entire rows when duplicate values found in two separate columns

Highlight duplicate rows based on 8 conditions (with one catch)

Highlight duplicate based on a different columns contents

highlight duplicate rows and delete based on highest value from column

[SOLVED] Highlight Duplicate Rows Based on Multiple Criteria

Excel 2007 : Highlight entire rows based on duplicate cells in one column

Highlight rows based on Duplicate with conditions

Bookmarks

Bookmarks

Posting Permissions