Conditional Formatting

Conditional Formatting

by M.L. Humphrey

NOOK Book(eBook)

View All Available Formats & Editions

Available on Compatible NOOK Devices and the free NOOK Apps.
WANT A NOOK?  Explore Now
LEND ME® See Details


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, and 50 Useful Excel Functions. In that series, conditional formatting is covered in Intermediate Excel.

Product Details

BN ID: 2940162049289
Publisher: M.L. Humphrey
Publication date: 06/01/2018
Series: Easy Excel Essentials , #2
Sold by: Barnes & Noble
Format: NOOK Book
Sales rank: 645,792
File size: 741 KB

About the Author

M.L. Humphrey is a former stockbroker with a degree in Economics from Stanford and an MBA from Wharton who has spent close to twenty years as a regulator and consultant in the financial services industry.

You can reach M.L. at or at

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews