Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting 2007 | Excel Worksheet Functions | |||
Conditional formatting 2007 | Excel Worksheet Functions | |||
Conditional formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
2007 Conditional Formatting entire row | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) |