Hi

I have created a dropdown list on sheet 1 and the data is saved on sheet 2 all is working fine, the data is a list of regular employees which I choose from the dropdown list. However I also enter manually overtime staff in the cell. My question is haw can I highlight say by colour any names entered into the cell that are not in the data for the drop down list

Thanks