Conditional Formatting for ICON Sets

[suresh ullanki]

Hi,

I was asked to show three triangels in separate column based on two columns using conditional formatting. i have two columns A and B. IF b2 greater than a2, c column should show icon sets.

[TABLE="width: 237"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Number[/TD]
[TD]Number2[/TD]
[TD]Conditional Format[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]7[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]8[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]12[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]15[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 237"]
<colgroup><col><col><col></colgroup><tbody></tbody>[/TABLE]

 

[Special-K99]

No expert in Icon Sets but try this.

in C2
=SIGN(B2-A2)
and copy down the column

Select C2
Then choose condtional formatting
Select Format all cells based on their values
Select icon Sets
Green where value is >= 0 Number
Yellow where value is > 0 Number

Hit OK, OK
Copy the format down the column using Format Painter.