conditional formatting 2007
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
|