Condition based cell color

[abhi234u]

Hi All,

I have a question if we can do a condition based for 6 conditions. I tried conditional formatting with icons but it has three conditions max. Is there an easy way for my colors to be in cells from A1 to AB80.

Thanks

 

[Fluff]

You can create 6 rules, one for each colour.

 

[abhi234u]

You can create 6 rules, one for each colour.

Hi,

I have to create 6 conditions for one cell. As the number can either be from 1 to 6. And the same conditions have to applied to cell from A1 to AB80.

eg: If (a1=1 then green color) elseif(a1=2 then light green color)elseif(a1 =3 then blue ) etc

Thanks

 

[Fluff]

You can select A1:AB80 & then create 6 separate rules
=A1=1
=A1=2
etc, etc

 

[abhi234u]

You can select A1:AB80 & then create 6 separate rules
=A1=1
=A1=2
etc, etc

Thanks mate. Worked like a charm.

 

[Fluff]

You're welcome & thanks for the feedback.