There is an add-in that will extend the conditions to 30 (I think).

http://xldynamic.com/source/xld.CFPlus.Download.html

Otherwise, your only other option is VBA code.

Biff

"Mo2" wrote in message
...
example:
IF A2 = "1",
shade cell E4 "green"

if A2 = 2, shade e4 blue
if 3, shade yellow
if 4, shade brown
if 5, shade orange
if 6, shade purple
if 7, shade black

Conditional formatting will only cover 3 conditions..so u see my problem..
so How would i do this?
is it possible to shade a cell as a result of an IF statement yielding
true/false?
(i'm looking for a way without resorting to vb code, as i dont know much
about it... but if there is no other way, i'm willing to learn)

thanks in advance for your help