CFIcon Sets............choose set you want.

CFManage RulesEdit Rule

Create the rules for green, yellow or red.

Note: you can choose to have Icon only or Icon and value shown.


Gord Dibben MS Excel MVP


On Fri, 27 Feb 2009 05:56:01 -0800, Emece
wrote:

Sorry I was not clear enough, I am using Excel 2007, so conditional formating
using icon sets is included. I want to display the icon in the same cell as
the value, I don't want to specify font or cell color, but display an icon.

Thanks for your help

"Stefi" wrote:

What symbols and where do you want to display, e.g. in the next cells? If so,
you can do that by setting font color of the adjacent cells.

Regards,
Stefi

„Emece” ezt írta:

I have several values in a column and I want to apply Conditional Formating
using icon sets, according to the following rules:

Value=0, green symbol
Value<0, red symbol
Value0, yellow symbol

Is this possible?

Thanks in advance
Regards,
Emece.-