Create Edgy To-Do or Checklists with Check boxes in Excel + Shortfall calculator

The ones who like to plan adores to-do lists as well. And if you are also the one who likes to strike a line or tick or dash or mark then this tutorial is...

Highlight instances in Excel charts in different colors with shaded bars in background

Suppose you have a variance chart and want to highlight those that require inquiry. Further suppose that you have two levels of inquiry: Variances that require moderate inquiry (highlighted by for example green color) Variance...

Highlight every Nth row in Excel Tables – How To

By default, every second row in Excel tables is highlighted and the other option is to turn highlighting off completely. Though it does help most often but often times we may find a need...