condtional formatting in office 2007 is not working properly

  • Thread starter Thread starter Ashish Parekh
  • Start date Start date
A

Ashish Parekh

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.
 
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.
 

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 formating 1
Conditional Format Excel 2007 6
Conditional Format Negative to Postiive Numbers w/3 Symbol Icon Se 2
Condtional Formatting - Inserting Rows 1
Wildcard In Condtional Formatting. 3
Copy condtional formatting in XL2007 for Windows 1
conditional formatting 2007 15
Conditional Formatting not working with percentages in excel 2007 1

Back
Top