Solved How to set ICON in Excel by comparing data in 2 Columns

July 6, 2016 at 05:25:00
Specs: Windows 7
I am having two column with current month profit & last month profit respectively Column A & Column B. I would like to compare both column & set the ICON (down Arrow & up Arrow ) based on result if A1 value greater than B1 set upper arrow else down arrow

See More: How to set ICON in Excel by comparing data in 2 Columns

Report •

July 6, 2016 at 07:29:06
✔ Best Answer
You didn't say where you wanted the arrows to appear, so I'll use C1 for this explanation.

1 - In C1, enter this formula: =IF(A1>B1,2,IF(A1=B1,1,0))
2 - Under the Conditional Formatting drop down, choose Icon Sets and then choose the Up arrow.
3 - Go back into Conditional Formatting and choose Manage Rules
4 - Edit the Rule for C1 as follows:
----- Click the Show Icon Only box to place checkmark in box
----- Change Type to be Number in both dropdowns
----- Up Arrow: when value is >=2
----- Sideways Arrow: when <2 and >0
----- Down Arrow: when <=0 (should be default)
5 - Click OK

Let me know how that works for you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question