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

[velasquez.m]

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.

 

[Roger Govier]

Hi

there seems to be a problem with using % in Conditional formatting.
Change your values to Numbers, and use
Green >=0.8
Yellow >=0.6
Red <0.6