Conditional Formatting not working with percentages in excel 2007
 

I have several columns of data with percentage values and I'm trying to use
some of the new, default conditional formatting options in Excel 2007 -
specifically the little pie chart icons. The formatting doesn't seem to be
applying correctly when I use percentages in the cells. It's as if the system
isn't even looking at the value in the cell and just choosing the first icon
in the list. I'm seeing similar problems using just about any of the default
formats against percentage values. Is anybody else seeing this kind of
weirdness?

Conditional Formatting not working with percentages in excel 2007
 

Dave

Works fine here. Are you sure these percentages are 'numbers' and not text
looking like numbers? (Try copying a blank cell highlighting your
percentages and selecting Paste special from the paste dropdown on the home
tab, clipboard chunk and select values and add)

Bear in mind the pies do not show actual values, they are just indicative of
quartiles

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Dave" wrote in message
...
I have several columns of data with percentage values and I'm trying to use
some of the new, default conditional formatting options in Excel 2007 -
specifically the little pie chart icons. The formatting doesn't seem to
be
applying correctly when I use percentages in the cells. It's as if the
system
isn't even looking at the value in the cell and just choosing the first
icon
in the list. I'm seeing similar problems using just about any of the
default
formats against percentage values. Is anybody else seeing this kind of
weirdness?