+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting data bars color gradient

  1. #1
    Registered User
    Join Date
    12-17-2008
    Location
    USA
    Posts
    5

    Conditional formatting data bars color gradient

    Well I thought this would be straightforward but it isn't. I want to use conditional formatting on a column with gradient type data bars that show different colors for ranges of cell numerical values from 0-1 (i.e. percent). E.g. a value of 0.1 has a bar 10% the width of the cell, up to 1 which the width of the entire cell. So far I have tried to use the format based on value minimum = 0 and maximum = 1 which as expected has bars proportional to the cell value. using 0-0.21 gets the same result but the bars are not proportional to the values. When I try to apply multiple rules for values of different ranges (e.g. 0-.2 is red, .2-.4, is yellow, etc.) I get bars for the first rule but not the second, as if I had only applied the first rule. I tried "stop if true" but the checkbox is disabled. The attached workbook is an example of what I am trying to do. The first column is a simple gradient bar using the range 0-1, the second 0.21-0.4, etc. The last column is ideally exactly what I want to see.
    Attached Files Attached Files

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Conditional formatting data bars color gradient

    It is possible only if use VBA code.

+ 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. [SOLVED] Conditional Formatting w/ Data Bars
    By NoMotion in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-20-2015, 02:24 AM
  2. Data Bars Conditional Formatting
    By benny66 in forum Excel General
    Replies: 7
    Last Post: 07-08-2014, 11:34 AM
  3. Apply gradient color in Error Bars
    By mindas99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2013, 11:01 AM
  4. Check Conditional Formating - Interior Gradient Color Values
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-07-2012, 01:52 AM
  5. Conditional Formatting Data Bars
    By Wak1234 in forum Excel General
    Replies: 0
    Last Post: 12-15-2011, 05:52 PM
  6. Gradient Filling in Conditional Formatting
    By Tommy1005 in forum Excel General
    Replies: 0
    Last Post: 02-21-2011, 11:43 AM
  7. Excel 2007 : Conditional Formatting - Data Bars
    By flaviocn in forum Excel General
    Replies: 3
    Last Post: 08-09-2009, 06:23 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