Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
condtional formatting in office 2007 is not working properly
I am trying set the conditional formatting by using the Icon sets . ( 3
colour sets) the output is not giving proper results. Icons are not forated/sets as per the value applied for filters. i.e. i have set up the three values e.g. 10 %, 10% to 20 % and 20% to set 3 diff. icons. However after applying the icons/condional formatiing it is not giving the correct icons setup for value. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
condtional formatting in office 2007 is not working properly
Shouldn't the data ranges for the 3 values be:
<10 %, 10% to 20 % and 20% and not 10 %, 10% to 20 % and 20% as originally stated. -- Kevin Backmann "Ashish Parekh" wrote: I am trying set the conditional formatting by using the Icon sets . ( 3 colour sets) the output is not giving proper results. Icons are not forated/sets as per the value applied for filters. i.e. i have set up the three values e.g. 10 %, 10% to 20 % and 20% to set 3 diff. icons. However after applying the icons/condional formatiing it is not giving the correct icons setup for value. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 2007 compatibility at office 2003 is not working for graphs | Excel Discussion (Misc queries) | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
XL 2007: Conditional formatting not saved properly | Excel Discussion (Misc queries) | |||
condtional formatting not working | Excel Worksheet Functions | |||
PAGE PREVIEW NOT WORKING PROPERLY IN EXCEL 2007 | Excel Worksheet Functions |