This is my first question here and I'm pretty new to Excel, but I have a
question about the Icon Set conditional formatting.
From what I understand it's intended for use of a range of cells.

However, I have a single cell that I want to display 1 of the 3 light icons
for based on a certain condition.

For example, this cell is a percentage.
If the percentage is greater than 80%, display a green light.
If the percentage is greater than or equal to 60% but less than or equal to
80%, display a yellow light.
If the percentage is lower 60%, display a red light.

Steps that I've done so far that don't seem to work:

1. Click on cell
2. Click "Conditional Formatting New Rule..." from ribbon
3. "Format all cells based on their values" is selected
4. Select "Icon Sets" from the format style drop down.

This is what I put the settings at:

Green when value is (Value) 80 (Type) Percent
Yellow when < 80 and = (Value) 60 (Type) Percent
Green when < 60

This does not work though.
I don't get the correct colors to display based on the percentage value.
The cell is formatted for "%" with two decimal places.

Shoot, I mis-typed the last line of the conditional formatting.
That last condition is obviously supposed to be a red light, not a green.

"MikeV" wrote:

This is my first question here and I'm pretty new to Excel, but I have a
question about the Icon Set conditional formatting.
From what I understand it's intended for use of a range of cells.

However, I have a single cell that I want to display 1 of the 3 light icons
for based on a certain condition.

For example, this cell is a percentage.
If the percentage is greater than 80%, display a green light.
If the percentage is greater than or equal to 60% but less than or equal to
80%, display a yellow light.
If the percentage is lower 60%, display a red light.

Steps that I've done so far that don't seem to work:

1. Click on cell
2. Click "Conditional Formatting New Rule..." from ribbon
3. "Format all cells based on their values" is selected
4. Select "Icon Sets" from the format style drop down.

This is what I put the settings at:

Green when value is (Value) 80 (Type) Percent
Yellow when < 80 and = (Value) 60 (Type) Percent
Green when < 60

This does not work though.
I don't get the correct colors to display based on the percentage value.
The cell is formatted for "%" with two decimal places.

you have a response to your posting in another group


--
Regards
Roger Govier

"MikeV" wrote in message
...
Shoot, I mis-typed the last line of the conditional formatting.
That last condition is obviously supposed to be a red light, not a green.

"MikeV" wrote:

This is my first question here and I'm pretty new to Excel, but I have a
question about the Icon Set conditional formatting.
From what I understand it's intended for use of a range of cells.

However, I have a single cell that I want to display 1 of the 3 light
icons
for based on a certain condition.

For example, this cell is a percentage.
If the percentage is greater than 80%, display a green light.
If the percentage is greater than or equal to 60% but less than or equal
to
80%, display a yellow light.
If the percentage is lower 60%, display a red light.

Steps that I've done so far that don't seem to work:

1. Click on cell
2. Click "Conditional Formatting New Rule..." from ribbon
3. "Format all cells based on their values" is selected
4. Select "Icon Sets" from the format style drop down.

This is what I put the settings at:

Green when value is (Value) 80 (Type) Percent
Yellow when < 80 and = (Value) 60 (Type) Percent
Green when < 60

This does not work though.
I don't get the correct colors to display based on the percentage value.
The cell is formatted for "%" with two decimal places.

On Feb 13, 8:52*am, MikeV wrote:
Shoot, I mis-typed the last line of the conditional formatting.
That last condition is obviously supposed to be a red light, not a green.



"MikeV" wrote:
This is my first question here and I'm pretty new to Excel, but I have a
question about the Icon Set conditional formatting.
From what I understand it's intended for use of a range of cells.

However, I have a single cell that I want to display 1 of the 3 light icons
for based on a certain condition.

For example, this cell is a percentage.
If the percentage is greater than 80%, display a green light.
If the percentage is greater than or equal to 60% but less than or equal to
80%, display a yellow light.
If the percentage is lower 60%, display a red light.

Steps that I've done so far that don't seem to work:

1. Click on cell
2. Click "Conditional Formatting New Rule..." from ribbon
3. "Format all cells based on their values" is selected
Never mind. I figured out what I was doing wrong.
I changed the type to "number" and went with 0.8 instead of 80% and it
works correctly now.

4. Select "Icon Sets" from the format style drop down.

This is what I put the settings at:

Green when value is (Value) 80 (Type) Percent
Yellow when < 80 and = (Value) 60 (Type) Percent
Green when < 60

This does not work though.
I don't get the correct colors to display based on the percentage value.
The cell is formatted for "%" with two decimal places.- Hide quoted text -

- Show quoted text -

Shows what happens if you stay in the orignal thread and post to one group only.

Roger G. told you that at 9:12AM in the other group.


Gord Dibben MS Excel MVP

On Wed, 13 Feb 2008 10:44:53 -0800 (PST), wrote:

Never mind. I figured out what I was doing wrong.
I changed the type to "number" and went with 0.8 instead of 80% and it
works correctly now.