Change Conditional Formatting Icon Set Color

[jrortiz_2]

Hi Guys,

I'm using a custom point arrow to change the conditional formatting icon set.
But cannot seem to get the right if function as well as the rule description.

My conditions are:
if the percentage is an increase of more than 30% - red arrow points up
if the percentage is an increase of less than 30% - yellow points right
if the percentage is a decrease of more 30% red arrow points down
if the percentage is a decrease of less than 30% yellow arrow points right

Percentage start with D3 and arrow starts with E4
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]0.00%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]45.62%[/TD]
[TD]red arrow up[/TD]
[/TR]
[TR]
[TD]18.75%[/TD]
[TD]yellow arrow right[/TD]
[/TR]
[TR]
[TD]-36.84%[/TD]
[TD]red arrow down[/TD]
[/TR]
[TR]
[TD]-5.00%[/TD]
[TD]yellow arrow right[/TD]
[/TR]
</tbody>[/TABLE]


to get the arrows im using this formula IF(D4="","",IF(D4>=$O$3,$P$3,IF(D4>=$O$4,$P$4,$P$5)))
from table array

percentage starts O3 and arrow in P3
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]30%[/TD]
[TD]arrow red up[/TD]
[/TR]
[TR]
[TD]29%[/TD]
[TD]arrow yellow right[/TD]
[/TR]
[TR]
[TD]30%[/TD]
[TD]arrow red down[/TD]
[/TR]
[TR]
[TD]29%[/TD]
[TD]arrow yellow right[/TD]
[/TR]
</tbody>[/TABLE]


My formatting rule are
=$D$4<$O$4
=AND($D4<$O$3, $D4>$O$4)
=$D$4>$O$3

Maybe I have missed on something but would appreciate your help. thanks