Keeping on Track

/
1 Comments

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

1 comment:

  1. I am SO impressed! I NEED to learn how to do this.

    ReplyDelete