View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Emece Emece is offline
external usenet poster
 
Posts: 82
Default 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.-