Items related to Mastering Excel: Conditional Formatting

Mastering Excel: Conditional Formatting - Softcover

Book 12 of 30: Mastering Excel

Moore, Mark

  • 4.50 out of 5 stars
    6 ratings by Goodreads
 
9781546878490: Mastering Excel: Conditional Formatting
Softcover
ISBN 10: 1546878491 ISBN 13: 9781546878490
Publisher: CreateSpace Independent Publishing Platform, 2017

Synopsis

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 cover:* Highlight Cell Rules* Top/Bottom Rules* Data Bars* Color Scales* Icon Sets* Using FormulasIn 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.

"synopsis" may belong to another edition of this title.

Publisher
CreateSpace Independent Publishing Platform
Publication date
2017
Language
English
ISBN 10 
1546878491
ISBN 13 
9781546878490
Binding
Paperback
Number of pages
60
Rating
  • 4.50 out of 5 stars
    6 ratings by Goodreads