Excel 365 Conditional Formatting: Easy Excel 365 Essentials, #2

By M.L. Humphrey

Conditional formatting is a way to take a data set and apply special formatting to certain results. It makes it much easier to see patterns as well as sort and filter your data. This book will walk you through the various options for applying conditional formatting to your data.

* * *

This book is part of the Easy Excel 365 Essentials series of titles. These are targeted titles that are excerpted from the main Excel 365 Essentials series and are focused on one specific topic.

 

If you want a more general introduction to Excel, then you should check out the Excel 365 Essentials titles instead. In this case, Intermediate Excel 365 which covers conditional formatting as well as a number of other topics, such as pivot tables and charts.

• Language: English
• Publisher: M.L. Humphrey
• Release date: Jan 3, 2023
• ISBN: 9798215222454

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 365 Conditional Formatting

ALSO BY M.L. HUMPHREY

Listing of all books by M.L. Humphrey

Excel 365 Essentials

Excel 365 for Beginners

Intermediate Excel 365

102 Useful Excel 365 Functions

Easy Excel 365 Essentials

Formatting

Conditional Formatting

Charts

Pivot Tables

The IF Functions

LOOKUP Functions

EXCEL 365 CONDITIONAL FORMATTING

EASY EXCEL 365 ESSENTIALS - BOOK 2

M.L. HUMPHREY

CONTENTS

Introduction

Conditional Formatting

Appendix: Basic Terminology Recap

About the Author

Copyright

INTRODUCTION

This book is part of the Easy Excel 365 Essentials series of titles. These are targeted titles that are excerpted from the main Excel 365 Essentials series and are focused on one specific topic.

If you want a more general introduction to Excel, then you should check out the Excel 365 Essentials titles instead. In this case, Intermediate Excel 365 which covers conditional formatting as well as a number of other topics, such as pivot tables and charts.

But if all you want is a book that covers this specific topic, then let’s continue with a discussion of how conditional formatting works in Microsoft Excel.

CONDITIONAL FORMATTING

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

Conditional formatting is a way to take a data set and apply special formatting to certain results. It makes it much easier to see patterns as well as sort and filter your data.

I often will use conditional formatting in conjunction with a two-variable analysis grid. For example, I might build a grid with number of hours worked across the top and hourly pay rate down the side to see which combinations of hours and pay let me reach my income goal.

Let’s say you need to make $500 a week. (I know, I wish that were how the world still worked, but just stay with me here.) Here’s what I would put together for something like that:

Two-variable analysis table of hours per week versus pay rate

I’ve applied conditional formatting to Cells C3 through H6 so that I can quickly see which combinations of