EXCEL
CONDITIONAL
FORMATTING
CHAMPION
(Excel Champions Series)
HENRY E. MEJIA
EXCEL CONDITIONAL FORMATTING CHAMPION
Copyright 2018 HENRY E. MEJIA
All rights reserved. No part of this publication may be reproduced, stored in any data retrieval system or transmitted in any form or by any electronic, mechanical, photocopying, recording or other means, without the prior written permission of the author, except in the case of brief reviews used in literary reviews and certain non-commercial uses provided by the Copyright Law.
ABOUT THE AUTHOR
Henry E. Mejia is an online entrepreneur who discovered the great benefit of knowing how to use Microsoft Excel at an advanced level, and now he devotes part of his time to creating books so that more people can enjoy free time and better opportunities that an Advanced Excel user can have.
Henry also realized that the vast majority of people give away a lot of their life in front of the computer. That time could be used in more productive or more enjoyable activities, only if people knew how to use Excel a little better.
The goal of Henry's books is to open the door for workers and business owners to use Excel more efficiently, so they can have more and better growth opportunities.
OTHER BOOKS BY THE AUTHOR
"THE ONLY EXCEL VLOOKUP FUNCTION BOOK YOU WILL EVER NEED" - Sales Manager of an Oil Products Manufacturing Company
FIND MORE ABOUT VLOOKUP CHAMPION HERE
THANK YOU
Thank you for getting this book. This book is all about showing you to use Conditional Formatting as fast as possible
If you want to help the author produce more books like this one please leave your honest review about this book on Amazon
CONTENTS
INTRODUCTION
Welcome to Excel Conditional Formatting Champion. This book was written to teach you quickly and easily the correct way to use the Conditional Format tool.
This book is part of the "Excel Champions" series and is written in a simple and clear language.
If you have ever used graphs in Excel or Power Point you will agree that is better to present data in a visually pleasing way, so that the information is better understood.
With Conditional Format you can highlight quantitative and qualitative data automatically, which will allow you to better communicate your ideas and allow your other colleagues to understand what you are trying to communicate.
It's time to start your journey to become an Excel Conditional Formatting Champion.
GET YOUR 13 PRACTICE SPREADSHEETS (.xlsx)
Before starting Chapter 1 I recommend you get your 13 practice spreadsheets. Those exercise files are free for everyone who purchases this book. They will serve you at the end of each chapter to reinforce what you have learned and make sure you have learned it well.
All you have to do is to send me an email to:
ems.online.empire@gmail.com
With the Subject CONDITIONAL FORMATTING PRACTICE SPREADSHEETS and saying:
"Hello, I bought your book EXCEL CONDITIONAL FORMATTING CHAMPION and I need the 13 practice spreadsheets"
I will gladly reply your email and send you the files.
Now you are ready to start Chapter 1. Lets go!
CHAPTER 1
WHAT IS CONDITIONAL FORMATTING AND WHICH ARE ITS BENEFITS?
In Excel, "formatting" means visually changing a cell. Some examples of format are:
Center the words
To align to the right
Fill the cell with one color
Underline the words
Words in bold
Modify the font color
Modify the size of the words
Conditionals in Excel are logical sequences that normally follow the pattern "If the CONDITION is met, then Excel FORMATS the cell". Some types of conditions are:
The value of the cell is lower or higher than other
The value of one cell is the same as another
The cell contains a certain letter, word or phrase
The values are duplicated within a group of several cells
The values are within a range of dates
The values are the minimum or maximum values within a group of cells
Many other conditions can be added
So, to explain it simply, CONDITIONAL FORMAT means to automatically format a cell (with any of the previous formatting options) when the condition we want is fulfilled.
"CONDITIONAL FORMAT means to automatically format a cell when the condition we want is met"
With the conditional formatting tool it is extremely easy to automatically highlight the information that interests you, allowing you to recognize important information for decision making in a matter of seconds.
CONDITIONAL FORMATTING EXAMPLES
EXAMPLE 1: Imagine for a moment that you need to find 10% of the higher values in the following table.
The conditional formatting tool helps you achieve it easily in less than 20 seconds. When you order Excel to find 10% of the higher values and color the cell in green automatically.
In this example, the condition was "10% of the top group values". The group consists of 65 values, 10% is 6.5, so Excel automatically formatted the 6 cells that are the higher.
EXAMPLE 2: Now we have a table with sales, names and brands of mobile phones. You want to find the 20 smallest values.
As I mentioned, with conditional format it is extremely easy to highlight information you need. In the image below you can see that in a matter of seconds you found the 20 smallest values.
The relevant information that you can obtain in this simple example is that:
Tonja is the one with the most difficulty to sell almost all the brands.
The brand that sells more easily is Motorola.
That information is very valuable to make decisions. In this simple example you can realize that conditional format is eally useful , now imagine the benefit you can get when you use that same tool for more complex situations.
EXAMPLE 3: Now you have a similar table with the profits per company and you want to know the best ones, the average ones and the worst ones. Also you want to know which year was the best, and you want the information in a simple and visual way.
Notice that in a matter of seconds you can color the values in a degraded way, the one with the darkest color is the highest value, the one with no color is the lowest value, and all the intermediate ones are shown with a color scale .
Additionally to the right is the sum of all of the sales of each year, which includes a bar visually indicating the information in the form of a graph. Those two things can also be done with conditional formatting.
The number of situations in which conditional formatting can be used are a lot and it usually offers a quick and visually comfortable solution to analyze and present information.
QUICK CHAPTER SUMMARY:
The Conditional Formatting tool is used to format a cell automatically.
Next page