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.-

See the following entry that has explicit instructions on exactly what you're
trying to accomplish:

http://www.contextures.com/xlCondFormat03.html#Shape

Hope this helps...
--
Kevin Backmann


"Emece" wrote:

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.-

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.-

Thanks for your reply.
I tried to use that feature, but I cannot figure out how to specify the
conditions I need:
if Value=0, green symbol
if Value<0, red symbol
if Value0, yellow symbol

Can you please guide me?

Thanks in advance
Regards.
Emece.-
"Gord Dibben" wrote:

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.-