Conditional formatting Icon Arrows

[nigeo]

can the up an down arrows have there colours reversed, For example on
occassions I need the up arrow to appear red and down arrow green

 

[NBVC]

Go to Home>> Conditional Formatting and select Manage Rules...

Select the Rule you want to change and click Edit Rule.

There should be a checkbox at the bottom that allows you to Reverse
Icon Order (i.e toggle up/down arrow colours)


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)

 

[nigeo]

that does not change the arrow colour, the up arrow is always green,
sometimes i need the up arrow to be red

 

[NBVC]

Sorry.. misunderstood...

Not sure if it can be done..

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com