Not enough information to make much of a guess, but see help on Conditional
Formatting.


Gord Dibben MS Excel MVP

On Wed, 2 Dec 2009 15:44:01 -0800, guy325
wrote:

I wish to creat a senario that when certain names from a list are typed
within a range of cells, that they appear in a given color