Conditional Formating
 

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

Conditional Formating
 

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

Conditional Formating
 

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

Conditional Formating
 

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