View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DianneZ DianneZ is offline
external usenet poster
 
Posts: 13
Default 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