Mastering Excel: Conditional Formatting
No Customer Reviews
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.Like the other lessons, this lesson contains a link where you can download a follow along workbook and practice what is covered.Note: If you know about conditional formatting and consider yourself an Excel expert, this book is not for you. This is for Excel beginners who want to learn about this feature in plain English with no technical jargon.The images, exercises and workbook are for Excel 2013 for Windows. Most of the images and exercises will work with Excel 2010/2007 (but there may be slight differences). The workbook will not work with Excel for Mac
Format:Paperback
Language:English
ISBN:1546878491
ISBN13:9781546878490
Release Date:May 2017
Publisher:Createspace Independent Publishing Platform
Length:60 Pages
Weight:0.21 lbs.
Dimensions:0.1" x 6.0" x 9.0"
Customer Reviews
0 rating
Copyright © 2025 Thriftbooks.com
Terms of Use | Privacy Policy | Do Not Sell/Share My Personal Information | Cookie Policy | Cookie Preferences | Accessibility Statement
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
