Conditional Format

[Dez]

Hi,
I have a cell with a drop down menu with a list of 15 names, when I select a name from the list I would like the cell's background colour to change from white to yellow, but remain white while the cell is empty. If I use conditional formaing it allows only one name in the criteria and I have about 15, is there a formula the I can use to fix this???

Cheers

...Dez...

 

[Dez]

All is working fine now,

I had the drop down as the cell reference...

Thanks for all your help

Cheers

...Dez...