I am starting a new GANNT Chart and need help with the conditional formatting please..
I need 3 formulas one, I have worked out for the Planned Dates -
I also need to record the actual start date/finish (and use TODAY() somehow so if there is an actual start date, it records daily and stps when the actual finish date is put in
Also, I need to record the difference between planned end and actual end in a different colour
Assuming the project is ongoing (and today is 10 June)
(If dates are put in)...
I need 3 formulas one, I have worked out for the Planned Dates -
VBA Code:
=AND($H7>=M$5,$D7<N$5)
I also need to record the actual start date/finish (and use TODAY() somehow so if there is an actual start date, it records daily and stps when the actual finish date is put in
Also, I need to record the difference between planned end and actual end in a different colour
Assuming the project is ongoing (and today is 10 June)
(If dates are put in)...
Header | Cell references |
Planned Start Date | D7 downwards |
Planned Duration (Number of days) | E7 Downwards |
Actual Start | F8 Downwards |
Actual Duration (No. of days) | G8 Downwards |
Planned End | H8 Downwards |
Actual End | I8 Downwards |
Dates (ie 01 June, 02 June, 03 June etc | M5 across |
Attachments
Last edited: