Conditional Formatting not working with percentages in excel 2007

G

Guest

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?
 
N

Nick Hodge

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
(e-mail address removed)
www.nickhodge.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting 3
Excel 2007 - A Conditional Formatting ?'s 1
Excel conditional formatting with Weeknum 4
Excel 2007 conditional formating using 3 traffic lights on percent 2
conditional formatting in Excel 2007 1
Conditional Formatting of Percentages 2
Conditional formatting based on the sum of two cells (Excel 2007) 1
Question about conditional formatting of zeros in Excel 0

Top