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

0.00%
45.62%	red arrow up
18.75%	yellow arrow right
-36.84%	red arrow down
-5.00%	yellow arrow right

<tbody>
</tbody>

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

30%	arrow red up
29%	arrow yellow right
30%	arrow red down
29%	arrow yellow right

<tbody>
</tbody>

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