View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mo2 Mo2 is offline
external usenet poster
 
Posts: 34
Default IF condition is true, shade cell (more than 3 conditions)

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