Thank you it did work, but to avoid time wasting copy and pasting could you
do it for the entire column or A2 through A22 by showing it like
=OR(A2:A22="Chevy",A2:A22="Ford",A2:A22="Dodge") I tried this particular one
and it did not work...Help please

"Andy" wrote:

Hi

Try using =OR(A2="Chevy",A2="Ford",A2="Dodge")

Andy.

"Pritchett" wrote in message
...
I am trying to format a cell to bring back a certain font color when you
type
certain things. Example if I type "Chevy, Ford, or Dodge" in a cell I want
the font formatted red and if I type "BMW, Honda, Toyata" in the same cell
I
want the font formatted in blue. Basically I am trying to cond. format the
cell to change color with a word, but you only get three conditions. Would
that be considered "Cell value is" "equal to" and if so how do you
seperate
the info. ="Chevy, Dodge, Ford" or ="(Chevy, Ford, Dodge)" I have
tried many combo's to use it like a list but can not find the correct one.
Or
maybe what I am trying to do is just impossible at the moment. Any help
would
be grateful.