Conditional Formatting for ICON Sets

suresh ullanki

Board Regular
Joined
Apr 29, 2013
Messages
67
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.

NumberNumber2Conditional Format
12
67
78
81
92
103
1112
1415

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

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

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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.
 
Upvote 0

Forum statistics

Threads
1,215,516
Messages
6,125,280
Members
449,220
Latest member
Excel Master

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top