Microsoft Excel VBA Conditional Format Bar Chart

Đã hoàn thành Đã đăng vào Apr 3, 2014 Thanh toán khi bàn giao
Đã hoàn thành

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

Excel PHP Kiến trúc phần mềm Visual Basic Visual Basic cho Ứng dụng

ID dự án: #5759776

Về dự án

4 đề xuất Dự án từ xa Apr 3, 2014 đang mở

Được trao cho:

Aan12

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 / giờ
(19 Đánh Giá)
4.2

4 freelancer chào giá trung bình $17/giờ cho công việc này

ethicalboy

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 / giờ
(67 Nhận xét)
5.2
sayedzeeshan0

A proposal has not yet been provided

$16 USD / giờ
(17 Nhận xét)
3.2