the demo below the kalmstrom.com CEO Peter Kalmstrom shows how to format Excel
cells to visualize figures and changes in them. He uses a spreadsheet with
sales figures as an example, but the formatting he shows may be applied to
all kinds of data.
Peter uses Excel 2013 for his demo, but most of what he does is possible to
do in earlier versions also. He shows these different kinds of dynamic formatting
and explains how they work:
Conditional formatting rules
While demonstrating the conditional formatting Peter all the time explains
what he does, so while watching the demo you will get a lot of small tips
that make work in Excel easier.