Conditional Formating
 

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

Conditional Formating
 

Kevin tried to be a mind-reader but he also failed! I'm not familiar with
XL2007, but I don't think that a cell can contain values and icons at the
same time!

Regards,
Stefi

€žEmece€� ezt Ã*rta:

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

Conditional Formating
 

Check this:
http://office.microsoft.com/en-us/ex...100648451033#7

"Stefi" wrote:

Kevin tried to be a mind-reader but he also failed! I'm not familiar with
XL2007, but I don't think that a cell can contain values and icons at the
same time!

Regards,
Stefi

€žEmece€� ezt Ã*rta:

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

Conditional Formating
 

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