Conditional Formatting: Color AND Icons

bruntonomo

New Member
Joined
Jul 29, 2018
Messages
48
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: 2

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,112,772
Messages
5,542,445
Members
410,552
Latest member
Yogesh977
Top