Conditional Formating

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.
 
J

JWolf

Three conditions are:
formula is: =OR(A1=1,A1="S",A1="SP",A1="W")
formula is: =A1="SK"
formula is: =A1="C"
 
F

Frank Kabel

Hi
for the first condition you could use a formula like
=OR(A1="1",A1="S",A1="SP",A1="W")
 
K

Kevin

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
 
K

Kevin

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

David McRitchie said:
Hi Kevin,

=OR(A1=1,A1="S",A1="SP", A1="W")

Additional information on Conditional Formatting
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,

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.
Click to expand...
Click to expand...
 
F

Frank Kabel

Hi
yes change this to the cell for which you want to apply the conditional
format

--
Regards
Frank Kabel
Frankfurt, Germany

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

David McRitchie said:
Hi Kevin,

=OR(A1=1,A1="S",A1="SP", A1="W")

Additional information on Conditional Formatting
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,

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.
Click to expand...
Click to expand...
Click to expand...
 
D

David McRitchie

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

Kevin said:
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

David McRitchie said:
Hi Kevin,

=OR(A1=1,A1="S",A1="SP", A1="W")

Additional information on Conditional Formatting
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,

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.
Click to expand...
Click to expand...
Click to expand...
 
O

Oda Yujiro

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!
 
Top