| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I apply icon sets to percentage values in Excel worksheet?
When applying arrow icon sets as conditional formatting in a worksheet, where
the values are expressed as percentages (as a result of a formula) the arrows that are shown DO NOT match the what they should be based on the values that I enetered for each range. (It appears that Excel is using a Percentile basis not the actual percentages!?!) Is there a way to fix this? Thank you for any insight that may be offered. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I apply icon sets to percentage values in Excel worksheet?
One guess - it's the underlying calculated value/s
You could try using ROUND, eg something like this in the CF's formula: =round(A1,2)0.5 instead of: =A10.5 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Still Learning?" wrote: When applying arrow icon sets as conditional formatting in a worksheet, where the values are expressed as percentages (as a result of a formula) the arrows that are shown DO NOT match the what they should be based on the values that I enetered for each range. (It appears that Excel is using a Percentile basis not the actual percentages!?!) Is there a way to fix this? Thank you for any insight that may be offered. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Additional Icon Sets | Excel Discussion (Misc queries) | |||
| How to create icon sets for excel 2007 conditionnal formating ? | Excel Discussion (Misc queries) | |||
| how do I apply values to axis?(excel graph) | Charts and Charting in Excel | |||
| Excel 2000...Click on different Worksheet...Get a New icon and can | Excel Discussion (Misc queries) | |||
| How can I get excel to apply values in a cell before or after date | Excel Worksheet Functions | |||
Hybrid Mode
