Conditional Formatting In Excel
An Excel tutorial by Peter Kalmstrom
In
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
- Color Scales
- Icon Sets
- Conditional formatting rules
- Form Control
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.
|
Software that enhances SharePoint |
Kanban Task Manager
Visualize and co-operate on projects and tasks in SharePoint
and/or Outlook |
Pivot Explorer
Visualize and analyze list data in SharePoint |
Templates Manager
Find, use, manage and distribute Office templates in SharePoint |
Calendar Browser
Resource booking in SharePoint calendars |
|