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