Conditional Formatting is an excellent analysis tool that allows a user to change the formatting of their results when certain criteria are met. For example, the top 10% or values within a specified range. It allows a user to easily visually flag those results that are of most interest.


* * *


The Easy Excel Essentials 2019 series of titles are for intermediate-level users who want to focus on one specific topic such as PivotTables, Charts, Conditional Formatting, or the IF Functions.


The content of each title is extracted from either Excel 2019 Intermediate or Excel 2019 Formulas & Functions which cover intermediate-level Excel topics in more detail.
These books are written using Excel 2019 and assuming that a user is working in that program. If you are using an older version of Excel, the Easy Excel Essentials series may be a better choice since it was written using Excel 2013 and for a more general audience of Excel users.