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