I am working in a railway project as planner. How can i create a dynamic strip chart in excel?
Assume total length be 10 kilometers and each cell of 100 meters.
If I update the progress from 9.01 kms to 9.08 kms in the table, how the cell gets highlighted corresponding to the entered chainages.
The worksheet above shows you km in column A and highlighted cells in column B, if they are complete in the excel defined table.
You can easily add or remove values to the excel defined table without the need to adjust the conditional formatting formulas.
Conditional formatting formula applied to cell range B1:B101: