View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Still Learning? Still Learning? is offline
external usenet poster
 
Posts: 1
Default 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.