Well, the 39% should appear as yellow, not red as red applies only to cells
<33%. What I did is put 100 % in a cell, 50% in the cell below it and 0% in
the cell below that and hid the percents with a custom format of ;;; (3
semicolons). Then I included the 3 cells with your range. Excel made the
percents from 69% and higher have the green icon and the cells from 39%
through 54% have the yellow icon. The 100% cell had the green icon, the 50%
cell the yellow icon and the 0% cell the red icon. Then in those 3 cells to
their right I entered 67%, 34% to 67% and <33% to act as a legend for your
range. Excel is treating the icons just as it does the data bars and color
scales; that is, it is comparing the cell contents with other cells in the
range to determine the result. It is not comparing icon percents with 0%
through 100% which is why it is disconcerting. Perhaps in the future, MS
will make the percent selection in the rules mean just that. And to
accomplish that, they'll probably have to put a new option in the Excel
options to allow for that so as to not disturb existing workbooks.

Tyro
..

"DianneZ" wrote in message
...
Distribution Capacity
Atlantic 75%
Southwest 73%
Northwest 69%
North Central 54%
Mountain West 51%
Northeast 47%
Central 41%
Midwest 40%
Southeast 39%
the results of conditional formatting don't make sense to me,
on the example provided above :
if I apply "Icon sets" that look like the traffic lights
it applies green when value is = 67 %
applies yellow when value is <67% and = 33%
applies red when <33%

But in fact the last four values on the list show as red????
In my estimation only the last value should show as red...
Am I missing something here??
Thanks!
Dianne