Conditional Formatting: Color AND Icons

B

bruntonomo

Board Regular
Joined
Jul 29, 2018
Messages
67
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I'm looking to create a cell that shows the positive or negative difference between two cell values. I'm using the following formula to calculate the difference.

Code: 
=IF(B2>C2,+B2-C2,C2-B2)

What I'm having trouble with is getting conditional formatting to change both the color of the cell and the icon in the cell. When one cell's value is greater than the other, I want the cell to show green and an up arrow icon. When the first cell's value is less than the second cell, I want it to be red with a down arrow icon. Please see attached image. How can I do this?
 

Attachments

  • UpDown.png
    UpDown.png
    2 KB · Views: 7

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
You must log in or register to reply here.

Similar threads

S
  • Question
Icon Set or Arrows Conditional Formatting
Replies
2
Views
404
Seamus123
S
M
  • Question
ICON set auto change based on cell value.
Replies
1
Views
128
bobaol
B
O
  • Solved
Icon Set Conditional Format from other cell value
Replies
3
Views
445
ollyhughes1982
O
V
  • Solved
Conditional Formatting Formula
Replies
2
Views
493
awoohaw
awoohaw
G
  • Question
Conditional format based on icon sets for relevant reference
Replies
0
Views
357
gazmoz17
G

Forum statistics

Threads
1,214,667
Messages
6,120,822
Members
448,990
Latest member
rohitsomani

Share this page

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