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.