IF condition is true, shade cell (more than 3 conditions)
Hey Mo2
Check your last post JE McGimpsey has what you need
"Mo2" wrote:
i cant use conditional formatting becuz i have more than 3 conditions
if A1 = 1 , shade cell e4 "blue"
if 2, green
if 3, yellow
if 4, orange
if 5, brown,
if 6, purple
and so on.
is it possible to do it thru an IF statement?
how would i do this ? pls help
If coding is required, pls be specific and stuff (i'm very new to coding
and i might have trouble following)
thanks in advance
|