gantt chart help

[natemorris]

i am working on gantt chart i have the conditional formatting i need the problem is to give the chart values so i can total my data on the bottom i will attach the fileNate's project blank form.xlsx

[Cheeky Charlie]

Move your formula from conditional formatting to the cells themselves, then add them up.

[natemorris]

i dont understand i am ok with excel not great i tried it got bad results, i have the formatting for the gantt chart but i need the green area to hold the value of the crew size column on the same row so i can get a total men working based on the jobs we have. i know how to put a sum function in but cant seem to give the chart cells the value so i can add up for the total men working i have attached the file. sorry if it is hard to understand i am trying my best. thanksNate's project excell help.xlsx

[Cheeky Charlie]

So, I went to your first cell, H3, and opened the conditional formatting dialogue. Then I got the formula out:
=AND(H$2>=$F3,H$2<=$G3)
then I just adjusted it to return not true/false but the number of men working the team:
=IF(AND(H$2>=$F3,H$2<=$G3),$C3,0)
Then I copied and pasted this formula into H3 and copied it across & down.

To make it look neater you can format the cells with white text and make the conditional formatting change both cell 'pattern' and font colour to green.

Also, to make the worksheet run slightly quicker you can now use value is formatting on the cells:
value is not 0 then colour in cell

Finally, you'll need to prevent your cells erroring out causing a problem. Changing D3:
=IF(B3,QUOTIENT(B3,C3),0)
Works, although you may want to do something more cosmetic

[natemorris]

nates project 8 option 2.xlsx this is what i came up with. Thanks for the help and suggestions. I am still working on the final product.