Microsoft Excel VBA Conditional Format Bar Chart
$15-25 USD / giờ
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
ID dự án: #5759776
Về dự án
Được trao cho:
I can do it right now. When I have finished this task, I will advise you through this way. Give me twenty minutes. Thanks!
4 freelancer chào giá trung bình $17/giờ cho công việc này
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.