Home >Tips >Conditional formatting in Excel kalmstrom.com site map icon Site map  

Conditional Formatting In Excel

An Excel tutorial by Peter Kalmstrom

Excel iconIn 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:
  • Data Bars
    Excel Data Bars

  • Color Scales
    Excel Color Scales

  • Icon Sets
    Excel Icon Sets

    Excel Formatting Rules
  • Conditional formatting rules
    Excel Formatting Rules

  • Form Control
    Excel Format Controls

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.




Learn more



---------------------------------------------------------------------------------------







Always the latest news in the kalmstrom.com blog



Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!