Excel - 'Where else does this appear'

Say I have a timesheet.  I put in 'Mr A Bloggs' and wonder, 'What other entries were made for this client?'.

I know I can filter, but assume that is impractical for my purpose.  I could also highlight duplicates, but that would highlight every duplicate (so I believe).  I could even just search, but that's a little fiddly.

Any way I can highlight duplicates in a row based on one cell?  So consider B100 and highlight entries in B matching it?

Comments
There are 5 comments. Login or register to view them.

Conditional formatting

BKD |
BKD's picture

Thanks

Constantly Confused |
Constantly Confused's picture

A Macro

Steve Kesby |
Steve Kesby's picture

What I was thinking of ...

BKD |
BKD's picture

An extra column with the formula

ACDWebb |
ACDWebb's picture