View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Conditional Formating with Icon set - How to change the color

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.