Select the cells in which you want the highlighting
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula that refers to the active cell, e.g.:
=AND(A5<"",COUNTIF($A$1:A$4,A5)=0)
Click the Format button, and select the options you want
Click OK, click OK

Adnan wrote:
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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html