conditional formatting icon set

[jrortiz_2]

Hi Guys,

I need help. I want to use Icon set - 3 arrows.
I want to include an arrow that indicates increase and decrease daily based on it's yesterday data.

[TABLE="class: grid, width: 100, align: center"]
<tbody>[TR]
[TD]date[/TD]
[TD]Cost[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12/25[/TD]
[TD]549.38[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12/26[/TD]
[TD]821.03[/TD]
[TD]49.45%[/TD]
[/TR]
[TR]
[TD]12/27[/TD]
[TD]300.23[/TD]
[TD]-63.43%[/TD]
[/TR]
[TR]
[TD]12/28[/TD]
[TD]360.00[/TD]
[TD]19.91%[/TD]
[/TR]
[TR]
[TD]12/29[/TD]
[TD]504.00[/TD]
[TD]40.00%[/TD]
[/TR]
[TR]
[TD]12/30[/TD]
[TD]300.40[/TD]
[TD]-40.00%[/TD]
[/TR]
</tbody>[/TABLE]

If the increase of more than 40% then the arrow points up in red and if the decrease of 40% arrows points down in green. If inc and dec is more or less than 20% then side arrow in yellow. equal 40% inc dec side arrow. Thanks

 

[etaf]

as you want to change the default icon set
Red usually points down and Green up
BUT you want Red to point UP and Green to point Down
you will need to setup some custom pointers
https://www.extendoffice.com/documents/excel/4765-excel-change-icon-set-color.html

 

[jrortiz_2]

Thank You. this works!

 

[etaf]

you are welcome