Mastering Excel: Conditional Formatting

by Mark Moore

In this lesson we cover all the options for applying conditional formats to a workbook. Conditional formats are formatting rules that we can apply so when a cell's number changes, the format will change automatically. This is an excellent feature to use to draw a user's attention to outlying numbers, problem areas or to give a quick visual summaries of the data. We will * Highlight Cell Rules * Top/Bottom Rules * Data Bars * Color Scales * Icon Sets * Using Formulas In all the above, we will also go into how to customize all the options to make any report automatically update itself according to the criteria we set. Like the other lessons, this lesson contains a link where you can download a follow along workbook and practice what is covered.

61 pages, Kindle Edition

First published May 8, 2014

About the author

Librarian note:
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.