Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I display all conditional formatting in Excel? | Excel Worksheet Functions | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
Excel 2003 print problem with conditional formatting cell selected | Excel Discussion (Misc queries) | |||
Conditional formatting of a data series in an Excel Chart? | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) |