Format/ Conditional Formatting/ Formula is/ =COUNTIF($B$1:$B$4,$B1)1, then
choose your highlighting format.
--
David Biddulph

"Heine" wrote in message
ups.com...
Hi everybody,

has anybody any idea of how to somehow highlight or show if I have the
same value twice or more times in a column?

For instance

1 Tom
2 Dick
3 Harry
4 Tom


Then I would like to somehow hightlight Tom. Problem is I have a lot
of data I want to search through.

Any thoughts?

Best regards
Heine