+ Reply to Thread
Results 1 to 3 of 3

Conditional formatting for icon sets is not working properly

  1. #1
    Registered User
    Join Date
    04-16-2011
    Location
    Tallinn
    MS-Off Ver
    Excel 2010
    Posts
    34

    Conditional formatting for icon sets is not working properly

    Hi,

    I am trying to apply conditional formatting for icon sets. For some reason I do not get it working despite of very intuitive interface for it. Please see the attached file and intended value ranges for different colors.

    Also is it possible to apply conditional formatting through icon sets for single cells? For the row "Completion rate_YTD" I want to assign individual ranges.

    Thanks in advance,
    T
    Attached Files Attached Files

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,083

    Re: Conditional formatting for icon sets is not working properly

    Hi,

    You should be using Number rather than Percent and the values 0.9 and 0.85. If you specify percent, the values are a percentage of the spread of the numbers you apply them to.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    04-16-2011
    Location
    Tallinn
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: Conditional formatting for icon sets is not working properly

    Thanks that solved, logical

+ 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 icon sets
    By DON_BLACK in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-05-2014, 01:30 PM
  2. Conditional Formatting with icon sets
    By CharN in forum Excel General
    Replies: 1
    Last Post: 12-29-2011, 06:34 AM
  3. Conditional Formatting Icon Sets
    By pauldaddyadams in forum Excel General
    Replies: 2
    Last Post: 11-23-2011, 02:43 PM
  4. Using icon sets in conditional formatting
    By howardphillis in forum Excel General
    Replies: 9
    Last Post: 11-16-2009, 09:16 AM
  5. Conditional Formatting with Icon Sets
    By MCofman in forum Excel General
    Replies: 1
    Last Post: 05-01-2009, 03:03 PM
  6. Excel 2007 : Conditional Formatting Icon Sets
    By Saminam in forum Excel General
    Replies: 2
    Last Post: 04-15-2009, 03:04 PM
  7. Excel 2007 : Conditional Formatting using Icon Sets
    By Justinetme in forum Excel General
    Replies: 2
    Last Post: 04-10-2009, 08:46 AM

Tags for this Thread

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