software

I am trying to format a cell to bring back a certain font color when you type
certain things. Example if I type quot;Chevy, Ford, or Dodgequot; in a cell I want
the font formatted red and if I type quot;BMW, Honda, Toyataquot; 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 quot;Cell value isquot; quot;equal toquot; and if so how do you seperate
the info. =quot;Chevy, Dodge, Fordquot; or =quot;(Chevy, Ford, Dodge)quot; 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.

Hi

Try using =OR(A2=quot;Chevyquot;,A2=quot;Fordquot;,A2=quot;Dodgequot;)

Andy.

quot;Pritchettquot; gt; wrote in message
...
gt;I am trying to format a cell to bring back a certain font color when you
gt;type
gt; certain things. Example if I type quot;Chevy, Ford, or Dodgequot; in a cell I want
gt; the font formatted red and if I type quot;BMW, Honda, Toyataquot; in the same cell
gt; I
gt; want the font formatted in blue. Basically I am trying to cond. format the
gt; cell to change color with a word, but you only get three conditions. Would
gt; that be considered quot;Cell value isquot; quot;equal toquot; and if so how do you
gt; seperate
gt; the info. =quot;Chevy, Dodge, Fordquot; or =quot;(Chevy, Ford, Dodge)quot; I have
gt; tried many combo's to use it like a list but can not find the correct one.
gt; Or
gt; maybe what I am trying to do is just impossible at the moment. Any help
gt; would
gt; be grateful.
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=quot;Chevyquot;,A2:A22=quot;Fordquot;,A2:A22=quot;Dodgequot;) I tried this particular one
and it did not work...Help please

quot;Andyquot; wrote:

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

Hi

If you select A2:A22 and put that in, it will replicate itself over the
other cells automatically. So A3 will refer to A3 and so on.

Andy.

quot;Pritchettquot; gt; wrote in message
...
gt; Thank you it did work, but to avoid time wasting copy and pasting could
gt; you
gt; do it for the entire column or A2 through A22 by showing it like
gt; =OR(A2:A22=quot;Chevyquot;,A2:A22=quot;Fordquot;,A2:A22=quot;Dodgequot;) I tried this particular
gt; one
gt; and it did not work...Help please
gt;
gt; quot;Andyquot; wrote:
gt;
gt;gt; Hi
gt;gt;
gt;gt; Try using =OR(A2=quot;Chevyquot;,A2=quot;Fordquot;,A2=quot;Dodgequot;)
gt;gt;
gt;gt; Andy.
gt;gt;
gt;gt; quot;Pritchettquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am trying to format a cell to bring back a certain font color when you
gt;gt; gt;type
gt;gt; gt; certain things. Example if I type quot;Chevy, Ford, or Dodgequot; in a cell I
gt;gt; gt; want
gt;gt; gt; the font formatted red and if I type quot;BMW, Honda, Toyataquot; in the same
gt;gt; gt; cell
gt;gt; gt; I
gt;gt; gt; want the font formatted in blue. Basically I am trying to cond. format
gt;gt; gt; the
gt;gt; gt; cell to change color with a word, but you only get three conditions.
gt;gt; gt; Would
gt;gt; gt; that be considered quot;Cell value isquot; quot;equal toquot; and if so how do you
gt;gt; gt; seperate
gt;gt; gt; the info. =quot;Chevy, Dodge, Fordquot; or =quot;(Chevy, Ford, Dodge)quot; I
gt;gt; gt; have
gt;gt; gt; tried many combo's to use it like a list but can not find the correct
gt;gt; gt; one.
gt;gt; gt; Or
gt;gt; gt; maybe what I am trying to do is just impossible at the moment. Any help
gt;gt; gt; would
gt;gt; gt; be grateful.
gt;gt;
gt;gt;
gt;gt;