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.

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.