Hi,

I have a range of only names I wanted entered, anything that is not one of
these names I want to be highlighted somehow, maybe with IF Formula or
Conditional Formatting etc€¦

Here's an example:

A B
1 Adnan
2 John
3 Virgil
4 Jerry
5
6

So, anything entered in A5, A6 and so on, other then those four above listed
names to be automatically highlighted.

Your reply on this problem is greatly appreciated,

Best regards,
Adnan