Highlight duplicate cells within a column

[crwilson]

I understand how highlighting cells and/or formatting text goes but i'm struggling to highlight only cells which have duplicates within a column.

ie. I have usernames in column B starting at cell B2 and want to highlight any cells which have the same username. In the example below i'd be looking to highlight the duplicate cells for 'dave1234' and 'chris35'

dave1234
eric89
samantha21
dave1234
dave1234
chris35
johnny1999
barry_lynn
dave1234
angela_b
chris35
chris35

 

[GDH]

The conditional formatting dialogue box allows you to format cells which are duplicating.
Highlight the range and enter the keystrokes ALT O D and then choose format only unique or duplicate values.
Then choose duplicate values and the formatting desired.

If you wanted to only highlight the duplicate cells then you would need to use the following formulae within the conditional formatting dialogue box

=COUNTIF($A$1:A1, A1)>1

Assuming your data begins in cell A1.
Select the range and be sure to have the cell A1 as the active cell when entering the formula in the conditional formatting dialogue box.

 

[crwilson]

Many thanks for your reply.

Do you have any idea how to do this in VB as i want to add it to an existing Macro. I do this task multiple times per day, every day and want to try and automate it.

 

[GDH]

Unfortunately I am VBA novice... Perhaps there is a guru out there who can easily do it!

 

[crwilson]

Anyone?