highlighting cell if same value appears in column

Hi guys an easy one I suspect.

I have a list of staff names in say column H, I'm entering staff names on a roster using drop down list in say column B. I need the names in column H to be highlighted (say cell colour changed) when the name is entered into column B.

To simplify, this is to indicate any staff not entered in column (any cells that have not changed in colour)

Any help would be appreciated.

David

Hi

select h1
go to Format - Conditional formatting -Click the dropdownbox to change to formula is and enter =COUNTIF($B$1:$B$9,H1)>0 in the next field ( adapt the range to your needs)
Select the highlighting you want
OK
Then copy the format to the rest of col H

Thanks your a star