Need more than 2 conditions in Conditional Formatting
Is there a way to have more than just the 3 conditions in formatting or to
work around it?
I have a range of b4:b35 and I need to highlight cell different colors
depending on cell value..
If cell =0 then fill with red
if cell =1 then fill with yellow
if cell = 2 then fill with green
if cell = 3 then fill with blue
if cell =off then fill with grey
so as of right now I need 5 conditions unless oen of you wonderful experts
out there have an alternative solution for me....
thank you in advance
|