Keeping on Track


My secret forbidden love of spreadsheets gets an airing now and then, and now is one of those times.

You see that (B5)? That's a countdown timer to assessment that changes colour with conditional formatting depending on how close assessment is getting.

You see those (Row 2)? Those are wieghted percentages of jobs todo/partially done/done, again with conditional formatting for a quick-glance-what-needs-to-be-worked-on cool cat kinda style. With a nice overall Project Complete percentage (B2).

You see all those jobs to do? BOOM! Conditional formatting to separate their individual completeness.

Spreadsheets are wonderful.


You may also like