Function Help,????

  • Thread starter Thread starter Jason
  • Start date Start date
J

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.
 
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
 
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.
 
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.
 
Back
Top