Microsoft Excel VBA Conditional Format Bar Chart

Hi I think I have a pretty simple excel vba problem here. i need to change the colors of the bars on a bar chart based on cell values. See the attached file and it should make sense. Essentially the chart should be colored as shown in the sheet based on the data shown in C29:D38. I just manually colored the bars for explanation purposes. the conditions for the colors should be

- if production < hours then the production bar should be red

- if production is = or > then hours the production bar should be green

- if hours is < or = to 100% then the bar should be light green

- if hours is > 100% then the bar should be light red

PM me with questions. looking to get this done tonight so first person to get it will get paid. thanks

Beceriler: Excel, PHP, Yazılım Mimarisi, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: microsoft excel software, make a chart, microsoft vba, microsoft excel VBA, me vba, excel vba with, excel vba or, excel vba and, simple excel, light production, excel/vba, excelchart, think vba, chart bar chart, production sheet format, vba architecture, excel format cell, excel cell format, excel change data format, format cell

İşveren Hakkında:
( 26 değerlendirme ) Gates Mills, United States

Proje NO: #5759776



I can do it right now. When I have finished this task, I will advise you through this way. Give me twenty minutes. Thanks!

$15 USD / saat
(19 Değerlendirme)

Bu iş için 4 freelancer ortalamada $17/saat teklif veriyor


Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [login to view URL] Looking for further discussions in this matter. with than Daha Fazla

$21 USD / saat
(77 Değerlendirme)

I am creating a formula for i t and I think it is better than vba, if you can wait about 55 min I will deliver the formula to you.

$15 USD / saat
(67 Değerlendirme)

A proposal has not yet been provided

$16 USD / saat
(17 Değerlendirme)