Change Conditional Formatting Icon Set Color

jrortiz_2

New Member
Joined
Dec 28, 2016
Messages
23
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
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,129,843
Messages
5,638,677
Members
417,041
Latest member
Molo

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
Top