Setting an Icon Set conditional format for a single cell???

[MikeV]

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.

 

[MikeV]

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.

 

[Roger Govier]

you have a response to your posting in another group

 

[velasquez.m]

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.

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.

 

[Gord Dibben]

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