data bars

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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
  14. 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...
  15. 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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top