ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   condtional formatting in office 2007 is not working properly (https://www.excelbanter.com/excel-discussion-misc-queries/218460-condtional-formatting-office-2007-not-working-properly.html)

Ashish Parekh

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.

Kevin B

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.



All times are GMT +1. The time now is 05:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com