+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting-New Rule based on icon sets according to value(%) does not execute

  1. #1
    Registered User
    Join Date
    05-09-2014
    Location
    Massachusetts
    MS-Off Ver
    2010
    Posts
    2

    Conditional Formatting-New Rule based on icon sets according to value(%) does not execute

    Hello,

    I'm trying to insert a simple conditional formatting rule - icon sets according to rule percentages I've selected (Green > 90%; Yellow < 90% but > 80%; < 80% red). The conditional formatting does not work once i select okay. For example. The data set shows 95% as red, 83% as red, it's just not working for me. I've tried opening a new workbook, new worksheet and nothing seems to work. I've been able to do insert this rule based on "number" setting but unsuccessful with percentages. I've tried for hours and have not had any luck, if anyone could shed some light on this problem, show me what i'm doing wrong i would greatly appreciate it.

    Thank you,

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,082

    Re: Conditional Formatting-New Rule based on icon sets according to value(%) does not exec

    Change the percentage to number (>=0.9, >=0.8, <0.8) and it works

    Source: http://answers.microsoft.com/en-us/o...9-571dad1fd828
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    05-09-2014
    Location
    Massachusetts
    MS-Off Ver
    2010
    Posts
    2

    Re: Conditional Formatting-New Rule based on icon sets according to value(%) does not exec

    Thanks Special-K. So what i discovered in addition to your recommendation is --> in the drop down select "number". In the excel sheet you can leave the numbers as percentages, as long as you make the changes on the rules menu.

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting and Icon Sets
    By rrob74 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-12-2013, 03:48 AM
  2. [SOLVED] Conditional Formatting - setting up a icon set rule for traffic light icons??
    By David Johnstone in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 03-26-2013, 05:47 PM
  3. Conditional formatting with icon sets
    By malbar in forum Excel General
    Replies: 6
    Last Post: 11-16-2011, 10:18 AM
  4. Conditional Formatting with Icon Sets
    By MCofman in forum Excel General
    Replies: 1
    Last Post: 05-01-2009, 03:03 PM
  5. Excel 2007 : Conditional Formatting Icon Sets
    By Saminam in forum Excel General
    Replies: 2
    Last Post: 04-15-2009, 03:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1