data bars

  1. G

    Data Bar Min Not Showing Up

    Good Morning, I'm setting up 3 Data bars for 3 ranges 90-100 60-89 0-59 The problem I'm finding is when I set the Minimum Number for the data bar (gradient or solid), it doesn't show any color in the cell. The other issue is that the cell is not responding to the other rules. The first rule...
  2. B

    Changing data bar colour based on value?

    Is there a way that you can conditionally format a data bar to a different colour, depending on value? So if it was '0-34%' it would be red, '35-75%' it would be amber etc. ? I don't want to make a bar graph as this information is in a table. I have seen a few instructions on how to do this...
  3. B

    Conditional Formatting and Relative References?

    Hello, I am no Excel master to any degree so I may be overlooking a really clear and obvious answer, but I'm trying to solve the following problem: Basically all I'm doing is tracking a set of videos on a particular YouTube channel and what their projected viewcounts will be in the future. I...
  4. T

    Conditional Formatting

    hi all, I am trying to use conditional formatting to color format a total by 3 different cells... can someone tell me if this can be done? Singles Doubles Triples Total 100 50 40 190 I want to show 190 with the proper colored percentages from...
  5. W

    Data Bars Formatting Question

    I have made a budget sheet on excel and I have a few columns per month. Category, Budget, Actual, Remaining. My question pertains to the Budget, Actual, And Remaining sections. Currently I have an Amount X in the budget column that remains constant. In the Actual column I have a formula that...
  6. J

    Data Bars not showing on Dashboard

    Good Day I am using a spreadsheet with some tabs that are published as web pages so that we can display them on TV`s as dashboards. In one dashboard we have some targets, I am using the data bars from conditional formatting to gradually color in the cell as we progress. It works great however...
  7. W

    Data Bar Values

    I have made a budget sheet on excel and I have a few columns per month. Category, Budget, Actual, Remaining. My question pertains to the Budget, Actual, And Remaining sections. Currently I have an Amount X in the budget column that remains constant. In the Actual column I have a formula that...
  8. W

    Data Bars to show Percentage

    I have made a budget sheet on excel and I have a few columns per month. Category, Budget, Actual, Remaining. My question pertains to the Budget, Actual, And Remaining sections. Currently I have an Amount X in the budget column that remains constant. In the Actual column I have a formula that...
  9. P

    Data Bars Based on Text Values with Drop Down List

    I have a table with one of the columns having a drop down list with 9 options. The drop down list takes it's options from a list elsewhere in the spreadsheet, as standard. I understand how conditional formatting data bars works, using numbers in a range and filling out the bar based on the...
  10. K

    Set maximum for data bars in adjacent column

    How can I apply conditional formatting to show data bars based on a long array of numbers in column B relative to a corresponding array of maximum values in column C? I have tried adding a formula to set the maximum value based on $C5, but it complains that I can't use relative references with...
  11. M

    conditional formatting data bars with multiple ranges?

    Is it possible format data bars (bar chart inside the cell) with multiple ranges? Eg Value < 0 = Red Value between 0 – 20 = Orange Value between 20 -50 = Green Value > 50 = Blue i know this is possible with other types of cond. formatting but i'm having trouble with the data...
  12. I

    Conditional Formatting Using Gradient Bars

    Hey everyone, thanks for your help with this question. I am working on a report for work and I am trying to give a simple visual to show how close a facility is to meeting their goal and thought I could use conditional formatting instead of adding an additional column to an already large data...
  13. J

    Colour Data Bars according to cell sign

    Hi guys, Ive been struggling with this... I have a table with a range of values (AE6:AE15) for which I want to show data bars inside the cells. I want the data bar configuration to be the shortest bar to correspond to the largest value and viceversa. However, this column has both negative and...
  14. C

    Change color of data bar conditionally

    Hi All, I'm trying to change the color of the data bar based on the value. With conditionally formatting, I'm able to change the fill of the cell, but I'd like to change the color of the data bar instead. Is this possible? Any help would be appreciated. Certified K
  15. B

    OFFSET Conditional Formatting in Excel

    Hi, I want to show in cell data bars for negative and positive but with the value in the middle, so three cells, left is negative, middle is actuall data, right in positive. I found a way a long time ago on chandoo (something like here...
  16. J

    Data Bars - older versions of Excel

    Hi, Is it possible to get something like the Data Bars in 2007 in older version of Excel? I would like to fill a cell with a color based on the value (0 to 100). So if the value was 50, only half the cell would be colored red. Also, in Excel 2007 ... when using Data Bars, if the value is zero...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top