Just wondering if its possible to formulate this steps into Microsoft Excel..

From the Activity, Predecessor and duration. it will highlight the required number of cells.

Activity A has no predecessor and 1 week duration so it will shade 1 cell

Activity B has A predecessor and 2 week duration, so it will shade 2 cell after Activity A has completed.

Activity C has A predecessor and 3 week duration, so it will shade 3 cell after Activity A has completed.

Activity D has B predecessor and 3 week duration, so it will shade 3 cell after Activity B has completed.

Attached image is an example of how its done manually. just wondering if possible to do it automatically on Excel

EDUSTREAM EARNED VALUE MANAGEMENT (EVM) ANALYSIS Activity Predecessor Duration Cost $ (Per Budget Activity Use cell colour fill in the table cells provided below to build your Gantt Chart (Precedence Diagram (Weeks) Week) Cost (BC) Method) for this project. It will help if you colour the duration in dark blue and the completed in red) D 1 $8,000 $8,000 A B A IN $5,000 $10,000 B A $6,800 $20,400 B 3 $4,500 $13,500 D B UT $5,500 $27,500 E 10 $8,700 $87,000 F - - IO TMO 10 $7,300 $73,000 G M W On D 5 $5,300 $26,500 H 10 $11,400 $114,000 - - 5 $9,700 $48,500 K D 5 $4,400 $22,000 K A 10 $9,200 $92,000 r M E 5 $3,500 $17,500 M BAC Week 2 3 4 5 6 7 8 9 10 11 12 13 14 15 The progress report at the beginning of Week 9 (as shown by the red line in the Gantt Chart above), gives the information provided in the left-hand table below. From this information