Excel conditional formatting
Excel conditional formatting is a really powerful feature when it comes to applying different formats to data that meets certain conditions. It can help you highlight the most important information in your spreadsheets and identify variances of cells’ values with a quick glance.
At the same time, Conditional Formatting is often deemed as one of the most intricate and obscure Excel functions, especially by beginners. If you feel intimidated by this feature too, please don’t! In fact, conditional formatting in Excel is very straightforward and easy to use, and you will make sure of this in just 5 minutes when you have finished reading this short tutorial.
The basics of conditional formatting
Cells, rows, or columns can be formatted to change text, icon, font color or background color if they meet certain conditions. For example, if they contain a certain word, number or a value.
Open an excel spreadsheet.
Select the cells you want to apply format rules.
Click Format and then Conditional formatting. A toolbar will open to the right.
Create a rule.
Single color: Under “Format cells if,” choose the condition that you want to trigger the rule. Under “Formatting color, choose what the cell color or font color look like if condition is true.
Color scale: Under “Preview,” select the color scale. Then, choose a minimum and maximum value, and an optional midpoint value. To choose the value category, click the Down arrow Down Arrow.
The same as usual cell formats, you use conditional formatting in Excel to format your data in different ways by changing cells’ fill color, font color and border styles. The difference is that conditional formatting is more flexible, it allows you to format only the data that meets certain conditions.
You can apply excel conditional formatting to one or several cells, rows, columns or the entire table based on the cell contents or based on another cell’s value. You do this by creating rules (conditions) where you define when and how the selected cells should be formatted.
CLICK ON THE HOME TAB.
CHOOSE CONDITIONAL FORMATTING
HIGHLIGHT CELL RULES
THAN CLICK ON GREATER THAN
5. CLICK ON THE DROPDOWN LIST.
6. CLICK ON CUSTOM FORMAT.
7.CHOOSE A CUSTOM COLOR.