+ Reply to Thread
Results 1 to 5 of 5

Is it possible to conditionally color databar based on background color of another cell

  1. #1
    Registered User
    Join Date
    03-09-2005
    Location
    Independence, Missouri
    MS-Off Ver
    2010
    Posts
    3

    Is it possible to conditionally color databar based on background color of another cell

    [SOLVED] Can a databar be the same color as the background color of another cell without VB code?
    Last edited by PizzaPete; 09-15-2012 at 08:20 AM.

  2. #2
    Registered User
    Join Date
    03-09-2005
    Location
    Independence, Missouri
    MS-Off Ver
    2010
    Posts
    3

    Re: Is it possible to conditionally color databar based on background color of another cel

    Let me clarify. Color of the bar depends on the value of another cell which is a calculated average from a pivot table. If value is 0 to 4 color = Red, if value = 5 color = Yellow, if value 6 or 7 then color = Green.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,883

    Re: Is it possible to conditionally color databar based on background color of another cel

    could you not reference those same values as criteria for the color bar?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    03-09-2005
    Location
    Independence, Missouri
    MS-Off Ver
    2010
    Posts
    3

    Re: Is it possible to conditionally color databar based on background color of another cel

    Just below the single row that had the calculated average I added 3 more rows. Each had conditions for mirroring their data of the calculated average cell above. For the first cell if the value was <= 2 then display the calculated average if not show "". The same followed for the next two cells down and increasing the threshold. Then made a side-by-side bar graph using those three rows. Making sure to overlap the bars so whichever bar appeared was in the same location as where the other two would have been.
    The last trick was to overlay that across the top of the original bar graph. I made the original bar 100% transparent so its M$ blue didn't show.

    If I would prefer if Excel would allow me to set conditions in the FORMAT DATA SERIES under FILL OPTION. But I may have to wait until the next release.

    Thanks

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Is it possible to conditionally color databar based on background color of another cel

    @ PizzaPete

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't properly marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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