Forum Discussion
Excel - Add value based on colour
Hi All, I have an excel sheet where I am trying to create a cash flow estimate based on a programme of building works. Column C has the planned week number, Column D has the planned duration...
Is it possible to have a file (without sensitive data) where you explain step by step what you intend to do?
Column B represents a planned activity.
Column C is the Planned Start of the activity.
Column D is the Planned Duration.
Columns I to CE are numbered in Row 6 to represent Week Numbers 1 to 60.
When you 'plan' the activity, for say, week 1 with a 1 week duration, the sheet is conditionally formatted to fill these cells in peach.
I then want the sheet to add the Forecast Value per Week from Column 8 into the peach cells.