Conditional Formatting

This title is printed to order. This book may have been self-published. If so, we cannot guarantee the quality of the content. In the main most books will have gone through the editing process however some may not. We therefore suggest that you be aware of this before ordering this book. If in doubt check either the author or publisher’s details as we are unable to accept any returns unless they are faulty. Please contact us if you have any questions.

Have you ever wanted to flag results in a data table that matched your criteria? Or wanted to see just by glancing which result in a list of values was the largest value or the smallest value? That’s what conditional formatting will let you do.

Conditional formatting allows you to take a range of cells and highlight those that are above or below a certain value. Or to add icons or bars or colored shading to a cell to show which are your largest or smallest values.

And you can either let Excel determine where to apply those criteria or you can set your own.

Once you learn how to use conditional formatting you will see just how powerful it is for analyzing data. So don’t hesitate. Learn about conditional formatting today.

The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, 50 Useful Excel Functions, and 50 More Excel Functions. In that series, conditional formatting is covered in Intermediate Excel.