Highlight rows if duplicates are found

P

Pierre

Have a long list of peoples names and their companies.
Some of the cells contents are duplicated, but are always in groups if
they are.

Would like to highlight the entire row if a contact is repeated, to
show that duplicate in a block of its own.
Would also like to avoid having shading color duplicated if the
duplication contains the same number of entries. Lets say, an entry of
1, followed fy an entry of 1; avoiding them both beigh the same color
shading if an entry is not repeated, but to differentiate it from the
previous entry. A greenbar for a data block (dating myself. . .) would
look would be just fine. Can create helper columns.

Using Excel 2007

For example:
Jones, Bill - Axel Manufacturing (green)
Jones, Bill - Axel Manufacturing (green)
Ventura, Ace - Metal Fabricators (white)
Ventura, Ace - Metal Fabricators (white)
Ventura, Ace - Metal Fabricators (white)
Ventura, Ace - Metal Fabricators (white)
Cavanaugh, Gus - ACA Limited (green)
Webster, Mirriam - Books R US (white)
Webster, Mirriam - Books R US (white)
Cortez, Angel - Safeco Insurance (green)
King, Larry - CNN (white)

Big thanks for any ideas on it's approach.
Pierre
 
G

Glenn

Pierre said:
Have a long list of peoples names and their companies.
Some of the cells contents are duplicated, but are always in groups if
they are.

Would like to highlight the entire row if a contact is repeated, to
show that duplicate in a block of its own.
Would also like to avoid having shading color duplicated if the
duplication contains the same number of entries. Lets say, an entry of
1, followed fy an entry of 1; avoiding them both beigh the same color
shading if an entry is not repeated, but to differentiate it from the
previous entry. A greenbar for a data block (dating myself. . .) would
look would be just fine. Can create helper columns.

Using Excel 2007

For example:
Jones, Bill - Axel Manufacturing (green)
Jones, Bill - Axel Manufacturing (green)
Ventura, Ace - Metal Fabricators (white)
Ventura, Ace - Metal Fabricators (white)
Ventura, Ace - Metal Fabricators (white)
Ventura, Ace - Metal Fabricators (white)
Cavanaugh, Gus - ACA Limited (green)
Webster, Mirriam - Books R US (white)
Webster, Mirriam - Books R US (white)
Cortez, Angel - Safeco Insurance (green)
King, Larry - CNN (white)

Big thanks for any ideas on it's approach.
Pierre
Click to expand...

One way...assume your data above is in A2:A12. In a spare column (I'll use B),
enter this formula:

=IF(A2<>A1,1,0)

Then use this for conditional formatting:

Formula Is =MOD(SUM($B$2:B2),2)

Select green for pattern.
 
P

Pierre

One way...assume your data above is in A2:A12.  In a spare column (I'lluse B),
enter this formula:

=IF(A2<>A1,1,0)

Then use this for conditional formatting:

Formula Is  =MOD(SUM($B$2:B2),2)

Select green for pattern.- Hide quoted text -

- Show quoted text -
Click to expand...

Glenn, Thank you!

Pierre
 
Top