Conditional Formatting highlights none duplicate based on rows & columns

**chaiyya345** · 03-01-2021, 02:09 AM

Hi All,

I'm trying achieve for conditional formatting to highlights the none duplicate values which is based on rows & columns. It is comparing with the row eg: (B2 & I2, C2 & J2, D2 & K2, E2 & L2, F2 & M2, G2 & N2) etc... (for easier reference, i have manually colored the columns). This is actually a reverse looking for the duplicate values, but I have no idea how to achieve this.

Please find attachment & any help is greatly appreciated.

Thank-You very much

**AliGW** · 03-01-2021, 02:35 AM

You can still use the duplicate values rule. First, set all cells to a colour, then set the duplicates rule to uncolour the cells that are duplicate, which should leave you with what you want.

**Sybon** · 03-01-2021, 02:44 AM

Hi...
U should use the new formula in the conditional formate. Then use =B2=I2 > Color
If you have any problem u can visit the below link
rb.gy/hunivd

**chaiyya345** · 03-01-2021, 03:03 AM

Hi AliGW,
Oh! it works! but with very much manual by selecting & pressing ctrl 1by1 the comparing cells.. is this how it should go?

Hi Sybon,
Thanks for sharing the link, I'll check out later.

Thank-You very much

**AliGW** · 03-01-2021, 04:08 AM

No - you apply the rule to the entire range.

**chaiyya345** · 03-01-2021, 04:26 AM

Sorry AliGW,
I dont really get you.

Duplicate worksheet:
I have apply the rule to the entire range but its all left with just 1 color (manually colored entire range to yellow & duplicate to white).

None-Duplicate worksheet:
it works. but as I mentioned, very manual since I want the comparing cells between B2 & I2, B3 & I3..etc.. (manually colored entire range to yellow & duplicate to white by ctrl 1by1)

I have attached the worksheet for better visibility.

Thank-You very much

**AliGW** · 03-01-2021, 04:50 AM

You've marked this as solved, so I presume you have found another way to do what you want.

**chaiyya345** · 03-01-2021, 04:52 AM

Sure AliGW,

Thanks for your help as always

Conditional Formatting highlights none duplicate based on rows & columns

LinkBack

Thread Tools

Rate This Thread

Display

Conditional Formatting highlights none duplicate based on rows & columns

Re: Conditional Formatting highlights none duplicate based on rows & columns

Re: Conditional Formatting highlights none duplicate based on rows & columns

Re: Conditional Formatting highlights none duplicate based on rows & columns

Re: Conditional Formatting highlights none duplicate based on rows & columns

Re: Conditional Formatting highlights none duplicate based on rows & columns

Re: Conditional Formatting highlights none duplicate based on rows & columns

Re: Conditional Formatting highlights none duplicate based on rows & columns

Thread Information

Users Browsing this Thread

Similar Threads

I need conditional formatting that compares two columns and highlights a third

[SOLVED] Conditional formatting based on rows AND columns

Conditional Formatting with 2 Highlights (IF condition)

[SOLVED] Conditional Formatting: Duplicate rows based on multiple columns.

[SOLVED] Conditional formatting of duplicate rows (not duplicate cells)

Conditional Formatting Help-highlights a single row

concatenate rows with columns based on conditional formatting in VBA?

Bookmarks

Bookmarks

Posting Permissions