Sorry, I'm a rookie. I have a roster of hockey players. 22 regulars and
many subs when regs are unavailable. When I type in subs names I would like
them to automatically be in red while the regulars remain in black.

"Gord Dibben" wrote:

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

.