Hi OssieMac,
Good day & thanks for the prompt reply. I tried before, however it doesn't
work as what expected. It just reversed the sequence but not the color. The
color still stay as Increase arrow = Green; Decrease arrow = Red

Any idea what else should I do ?
Thanks.

Jocelyn

"OssieMac" wrote:

Hi Jocelyn,

I assume you are working with xl2007.
Select the Conditionally formatted cells.
Click Conditional format button.
Select Manage rules.
Select the particular rule.
Click Edit Button.
Near the bottom center of the dialog box is a check box to Reverse Icon order.

--
Regards,

OssieMac


"Jocelyn" wrote:

Hi there,
I'm trying to change the color code for the Icon set(arrows).
The report I run and analysis, it show increase value as bad, and decrease
as good (improvement).

However, the arrows icon default as increase - green color; decrease - red
color.

Is anyone know how can I change the color code ? I need to show increase as
RED color and decrease arrow as Green. The opposite as the default color.

Thanks.