+ Reply to Thread
Results 1 to 4 of 4

Color Scale Conditional Formatting

  1. #1
    Registered User
    Join Date
    05-20-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2013
    Posts
    30

    Color Scale Conditional Formatting

    Hi,
    Need assistance on Color Scale Conditional Formatting

    I want to use formula to define Minimum, Midpoint and Maximum in the color scale, but am not able to achieve it.

    My Criteria are as follows;

    Minimum: Less than equals to 50%

    Midpoint: More than 50% less than 70%

    Maximum: More than 70%

    I need this formula for Accuracy column only.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,135

    Re: Color Scale Conditional Formatting

    Is this what you wanted? if not, please post again.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    05-20-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2013
    Posts
    30

    Re: Color Scale Conditional Formatting

    Am aware of what you have done.
    In your file I have added a screen shot which shows the 3 color scale and have filtered out formula.
    What I want to understand is whether I can use formula or not. Because when I try using formula, I get an error note.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,135

    Re: Color Scale Conditional Formatting

    What sort of formula were you trying to use?

    Don't forget that the formula is just calculating the value that will be used to set the maximum level of the colour scale (i.e. the most intense green, or the most intense red - at th eminimum end of the scale).

+ 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. Help with conditional formatting 3 color scale
    By ab0mbs in forum Excel General
    Replies: 1
    Last Post: 09-24-2013, 12:43 PM
  2. Using color scale conditional formatting on columns
    By moty.98 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-17-2013, 11:05 AM
  3. Using color scale conditional formatting on filtered data
    By moty.98 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-17-2013, 08:35 AM
  4. Conditional Formatting 3 color scale
    By Kagesen in forum Excel General
    Replies: 15
    Last Post: 05-03-2012, 08:50 AM
  5. conditional formatting with percentage color scale
    By timharper in forum Excel General
    Replies: 7
    Last Post: 12-16-2010, 12:34 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