Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2007 compatibility at office 2003 is not working for graphs Vinod[_2_] Excel Discussion (Misc queries) 0 December 4th 07 06:17 PM
sort function for dates does not sort properly in Office 2007 Exc. Rosalie Excel Worksheet Functions 1 November 22nd 07 10:25 PM
XL 2007: Conditional formatting not saved properly Pere Pete Excel Discussion (Misc queries) 0 August 17th 07 02:05 AM
condtional formatting not working Anzley Excel Worksheet Functions 4 September 14th 06 01:18 AM
PAGE PREVIEW NOT WORKING PROPERLY IN EXCEL 2007 Scott Dixon Excel Worksheet Functions 0 July 4th 06 03:52 PM


All times are GMT +1. The time now is 07:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"