If Statement to change the cell shading,

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

 

[J.E. McGimpsey]

Worksheet functions cannot change cell formatting.

Check the archives for answers to this FAQ:

http://google.com/advanced_group_search?q=group:*excel*

Use search terms like "conditional format more".