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 -