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.






Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved