Excel 2019 Conditional Formatting: Easy Excel Essentials 2019, #3

By M.L. Humphrey

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.

• Language: English
• Publisher: M.L. Humphrey
• Release date: Feb 15, 2021
• ISBN: 9781393059967

M.L. Humphrey

Hi there Sci Fi fans, my name is Maurice Humphrey.I am a Vermont native, husband, father, grandfather, well over 60, Navy veteran, retired IBM engineer, retired printer repairman, Graduated: Goddard Jr. College, VT Technical College, and Trinity College. Over the years I’ve written technical articles, taught technical classes, and presented at technical conventions.I’ve been reading science fiction for over 50 years now. First books were “Journey to the Centre of the Earth” by Jules Verne and “The Stars Are Ours” by Andre Norton. I’ve read and collected many great stories, and a considerable amount of junk ones as well. I’d say by now that I probably have a good idea of what I consider a good story.

Book preview

Excel 2019 Conditional Formatting

Also by M.L. Humphrey

Listing of all books by M.L. Humphrey

Easy Excel Essentials 2019

Excel 2019 PivotTables

Excel 2019 Charts

Excel 2019 Conditional Formatting

Excel 2019 IF Functions

---

Excel Essentials 2019

Excel 2019 Beginner

Excel 2019 Intermediate

Excel 2019 Formulas & Functions

---

Access Essentials

Access for Beginners

Intermediate Access

Excel 2019 Conditional Formatting

Easy Excel Essentials 2019 - Book 3

M.L. Humphrey

Contents

Introduction

Conditional Formatting

Conclusion

Appendix A: Basic Terminology

About the Author

Copyright

Introduction

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.

With that introduction, let’s dive in on how to use Conditional Formatting.

Conditional Formatting

What is conditional formatting and why would you want to use it?

At its most basic, conditional formatting is a set of rules you can apply to your data that help you see when certain criteria have been met.

I, for example, use it in my budget worksheet where I list my bank account values. I have minimum balance requirements on my checking