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.

Number	Number2	Conditional Format
1	2
6	7
7	8
8	1
9	2
10	3
11	12
14	15

<colgroup><col><col><col></colgroup><tbody>
</tbody>

<colgroup><col><col><col></colgroup><tbody></tbody>

 

[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.