Highlight rows based on Duplicate with conditions

**ypnOz** · 12-26-2010, 06:51 AM

Hello everybody,

I have been looking for an answer to my question but all the solutions i found where not exactly what i needed and i was not able to adapt them to my needs.

(excel file attached)
I am looking for a way to highlight the whole row, each time :
- Columns A , B , C and E are duplicates (need that they will all have the same duplicate values)
- Only IF column J is different

In the attached example, you can see that Rows 3 and 4 were highlighted but row 7 was not because it has a different value in column J

**zbor** · 12-26-2010, 07:03 AM

How about adding one more helper column and use it as criteria (in my example, last row also highlited... Is that OK?)

You can hide it if you don't want to see it.

**ypnOz** · 12-26-2010, 08:25 AM

Hi Zbor
First of all, thanks for this fast and interesting reply

I did not think of using a Helper column

2 things:
- The last row should Not be highlighted, that's the main concept. Because, even though the values in A, B, C and E are the same as the ones for Row number 3 and 4...the value in J differs.

-This is an extra request. Do you think there is a possibility to highlight just 1 out of many duplicate rows ? Sounds very difficult but the thing is i would like then to be able to Filter by Color and display only Unique rows based on the above conditions.
As it is, both rows will be highlighted and they will both disappears with the Color filter

Thanks

**ypnOz** · 12-27-2010, 04:25 AM

Could anyone help me with this please ? I kept looking on the web for an answer...could not find any

**ConneXionLost** · 12-27-2010, 04:57 AM

Modified zbor's result as attached.

**ypnOz** · 12-28-2010, 09:50 AM

Thanks a lot to both of you !!

Highlight rows based on Duplicate with conditions

LinkBack

Thread Tools

Rate This Thread

Display

Highlight rows based on Duplicate with conditions

Re: Highlight rows based on Duplicate with conditions

Re: Highlight rows based on Duplicate with conditions

Re: Highlight rows based on Duplicate with conditions

Re: Highlight rows based on Duplicate with conditions

Re: Highlight rows based on Duplicate with conditions

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions