data bars

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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...