Hello all.

I need some help again.

I need all cells in column A4 to A200 with multiple names (bob, steve, sue, Karen, etc) to highlight yellow with anything not listed to remain as default.

I know this is not the formula but something like:
=if(a2:A200="bob, steve, sue, Karen),turn name/cell yellow

Thanks for any help