Function Help,????

[Jason]

Hello. I am needing to do a conditional statement which
changes the cell shading. I've found Format/Conditional
Formatting, but I can only nest 3 levels down. I need to
nest 4 levels. If a, make cell shading red, b = blue, c
= yellow, and 4 = red. By default it needs to be none.
Can anyone offer a suggestion to help? I think I need to
use Functions, I can do an If then, but need to know how
to change the cell shading. TIA!!!!!!! Much appreciated.

 

[Andy Brown]

For cell shading, you're stuck with 3 -- no matter how many times you post.

You could use event code instead -- see
http://www.mvps.org/dmcritchie/excel/event.htm

Rgds,
Andy

 

[Jason]

Thanks for responses.. I found an easy macro via the
gogle search. Here is a link to the code within the
page...

Thanks again...

Jason

http://www.google.com/groups?
q=conditional+formating+more+group:*excel*&hl=en&lr=&ie=UT
F-8&oe=UTF-8&selm=e54j4%23FnCHA.1616%40TK2MSFTNGP12&rnum=2

 

[John Tjia]

Even though you have only 3 conditional formats, the condition that is
not a, not b and not c qualifies -- i.e., the "starting" format -- as
the fourth. What this means is that you should do something like
formatting the cell first as red (condition 4) and then have the
conditional format change that to a, b, or c.

 

[John Tjia]

Even though there are only 3 conditional formats, the starting format
-- i.e., when conditions 1, 2 and 3 are NOT met -- qualifies as the
fourth. So you can format your cell as red (condition 4), and when it
is not 1, 2, or 3, you are in the "fourth" condition.