Excel Progress Bar with Conditional Formatting that Changes Color Based on Value

 

Basically….. or not so basically as it turns out, I would like create a progress bar in Excel to show the progression towards hitting an incentive sales credit award that will change color based on the % completed towards goal.


There are two thresholds:


1. At 80% of goal, Employees will receive the BASIC award payout (everything below 80% receives no award)

2. At 110% and above of goal, Employees will receive the BONUS award payout 


I want the progress bar to follow the below color scheme format:


<80% =  Red Bar

>=80%, <110% = Green Bar 

>=110% = Blue Bar 


I want this to be one single bar that changes color based on the % values in another cell 


The bar itself would chart progress from 0% to a maximum of 110% (since there will need to be a cap in order to show progress and I assume if the cell value is 150% the progress bar would be fully filled in?)


If the Employee is at 60% of goal, the bar should be RED

If the Employee is at 90% of goal the bar should be GREEN (Changes from Red to Green at 80%)

If the Employee is at 125% of goal the bar should be BLUE (Changes from Green to Blue at 110%)


Is there some way to make this possible? even if it involves VBA?


Thank you so much! I have tried multiple work-arounds but nothing yields results close enough to what I am looking for.

By: Lydia

38 thoughts on “Excel Progress Bar with Conditional Formatting that Changes Color Based on Value

  1. Buy Reductil

    I have learn some excellent stuff here. Certainly value bookmarking for revisiting. I surprise how a lot effort you put to make one of these wonderful informative site.

  2. CBD For Lip Care

    Nice read, I just passed this onto a colleague who was doing some research on that. And he actually bought me lunch as I found it for him smile So let me rephrase that: Thank you for lunch! “Do you want my one-word secret of happiness–it’s growth–mental, financial, you name it.” by Harold S. Geneen.

  3. Acquistare Clitbuterol

    Does your site have a contact page? I’m having a tough time locating it but, I’d like to shoot you an e-mail. I’ve got some suggestions for your blog you might be interested in hearing. Either way, great site and I look forward to seeing it expand over time.

  4. 100 Natural CBD Oil

    Great post. I was checking continuously this weblog and I’m impressed! Extremely useful info particularly the remaining phase 🙂 I handle such information much. I used to be seeking this certain info for a long time. Thank you and good luck.

  5. click here

    I would like to thnkx for the efforts you have put in writing this blog. I am hoping the same high-grade blog post from you in the upcoming as well. In fact your creative writing abilities has inspired me to get my own blog now. Really the blogging is spreading its wings quickly. Your write up is a good example of it.

  6. ig

    Exceptional post however I was wondering if you could write a litte more on this topic?
    I’d be very thankful if you could elaborate a little bit more.
    Thanks!

  7. Sebastian

    Write more, thats all I have to say. Literally, it seems as though you relied on the
    video to make your point. You obviously know what youre talking about,
    why waste your intelligence on just posting videos to your
    site when you could be giving us something enlightening to
    read?

  8. see it here

    Fascinating blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple tweeks would really make my blog stand out. Please let me know where you got your theme. Thank you

  9. Buy Soma

    I¦ll immediately clutch your rss feed as I can’t in finding your e-mail subscription link or newsletter service. Do you have any? Kindly permit me know in order that I could subscribe. Thanks.

  10. Providencia Tuggie

    Hello very cool blog!! Man .. Excellent .. Superb .. I’ll bookmark your website and take the feeds additionally?KI am glad to seek out a lot of helpful info right here within the submit, we want work out extra strategies in this regard, thanks for sharing. . . . . .

  11. sling tv

    Hi, i think that i saw you visited my website thus i came to “return the favor”.I’m attempting
    to find things to enhance my web site!I suppose its ok to use some of your ideas!!

  12. sling tv

    Thanks for another informative web site.

    The place else could I get that type of information written in such a perfect method?
    I have a undertaking that I’m just now working on, and I have been at the glance out for such information.

  13. ps4 games

    My brother recommended I might like this website. He was entirely
    right. This post truly made my day. You can not imagine simply how much time I had spent for
    this information! Thanks!

  14. ps4 games

    Hello! I’ve been reading your web site for some time now and finally got the courage to go ahead and give you a shout out from Lubbock
    Tx! Just wanted to tell you keep up the excellent work!

  15. quest bars cheap coupon twitter

    When I initially left a comment I appear to have clicked the -Notify me when new comments are added- checkbox and from now on each time a comment is added I get 4 emails with the exact same comment.

    There has to be an easy method you can remove me from that service?
    Thanks a lot!

  16. plenty of fish dating site

    What i don’t understood is in truth how you’re not really a
    lot more neatly-preferred than you might be right now. You’re so intelligent.

    You know thus considerably on the subject of
    this matter, produced me individually believe it from numerous various angles.
    Its like women and men aren’t fascinated except it’s one thing to accomplish with Lady
    gaga! Your individual stuffs great. At all times take care of it up!

Comments are closed.