Conditional Formating

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Hi,

I want to format cells with specific colours. It appears that I'm limited
to 3 format options.

What I want to do is: if the cell contains:

1, S, SP, W, they are a green colour;
SK, is another colour; and
C, is yet another.

I tried to put, if equal to : "1", "S", "SP", "W" to no avail... can I even
do more than 3?.

Regards,
Kevin

P.S. I tried to find the answer, maybe I'm not asking the question
correctly?

Thanks again.
 
Three conditions are:
formula is: =OR(A1=1,A1="S",A1="SP",A1="W")
formula is: =A1="SK"
formula is: =A1="C"
 
Hi
for the first condition you could use a formula like
=OR(A1="1",A1="S",A1="SP",A1="W")
 
Thanks, so far so good, but now it immediately makes the cell green, and
when I input the values: 1, S, etc in the cell it turns the cell white...
pretty much opposite to what I'm looking for :-). I'm sure it simple, not
for me thought :-(

Kev
 
Hi David,

I replied to JWolf reply, thanks. Can I assume that the A1 is constant or
should I change that depending on what cell I'm in?

Kev
 
Hi Kevin,
Yes, but I think a little more to the point ...

Don't you want to use an entire column or something. Coloring
of cells is based on the selection, the formula is based on the
active cell.

If you want to color entire rows change the column address
portions to absolute. Once you get the hang of it they are easy.
But I would recommend reading my web page.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Hi! "Kevin", you might fall into a trap!
You may be happy if you do as follows:
****************************************************
#1. At first You have to select A1 depending on your problem.
(This is mandatory, very important.)
#2. Then Format Menu|Conditional Formatting.#3. With Conditional Formatting Dialog
3.1 Condition 1:
With Drop-Down List select "Formula Is", NOT "Cell Value Is"
Then (Condition Text Box) Enter formula:
such as =OR(A1=1,A1="S",A1="SP",A1="W")
then click "Format" Button,whichever you like.

3.2. Condition 2:
Click "Add Button" , then
With Drop-Down List select "Formula Is",
and enter =A1="SK"
....bra, bra..... so on.

#4. After you set A1, then still A1 selected,
click "format painter" then select
the other cells and click it ( "format-paste" them.)

That's it
Good Luck!
 
Back
Top