CONDITIONAL FORMATTING Articles: Excel and Google Sheets

All resources related to CONDITIONAL FORMATTING for Excel and Google Sheets.
All articles CONDITIONAL FORMATTING

CONDITIONAL FORMATTING

How to Insert Total Row in Excel
We can insert a total row in Excel by clicking the Design tab. With the Total row in our table, we can calculate several parameters automatically like average, maximum amount, minimum amount, etc. This tutorial will guide all levels of Excel users on how to use total rows in Excel....
Excel IF Function Examples – IF THEN, IF with Multiple Criteria, IF ELSE
Excel's IF function allows you to perform a logical test on your data and return one value if the result is TRUE and another if it is FALSE. There are a variety of ways to use the IF function, some more complex than others. This is a list of the...
Excel Conditional Formatting Examples – SUMIFS, Highlighting Cells, Copy-Paste
When you want to apply formatting in Excel based on certain criteria, it's called Conditional Formatting. This list of in-depth tutorials will help you find the answers you need so that you can learn and apply this useful function.  If you can't find what you're looking for or need answers...
Here’s How You Can Use Conditional Formatting If Two Cells Are Not Equal
Conditional formatting is one of the most useful functions of Excel. This step by step tutorial will assist all levels of Excel users in conditional formatting two cells that are not equal. Example 1 Figure 1. Setting the data This data refers to the total and obtained GPA of students....
Working with a Pivot Table that Has Conditional Formatting
We often want to enhance the layout and format of our pivot tables by using Conditional Formatting.  This step by step tutorial will assist all levels of Excel users in working with a pivot table that has conditional formatting, and learning to solve some common problems associated with it.  ...
How to Apply Conditional Formatting Between Sheets in Excel
Excel Conditional Formatting can be used to match values in different cells along with reconciliation of data. Final result is as follow: Figure 1 - Final Result Our data-set show readings extracted from computer system and values manually note down. Our goal here is to check if values extracted from...
Using Conditional Formatting in Excel Based on Another Cell’s Value
Conditional Formatting is a feature in Excel that allows us to change the format of cells based on a set of rules or conditions.  This step by step tutorial will assist all levels of Excel users in applying conditional formatting based on another cell’s value.  Figure 1.  Final result: Conditional...
How Do You Do Conditional Formatting with 2 Conditions?
The conditional formatting is used to create visual differentiation in a large set of data, in some standard format. Normally, the data can be visually differentiated using one or more rules, however, in this article, we will discuss how to apply conditional formatting with 2 conditions. Figure 1 - Final...
Using Conditional Formatting Times in Excel
Excel provides conditional formatting features for cells or ranges, using which, rule-based formatting standards can be applied easily. In this article, we will learn how to apply conditional formatting for time values in Excel. Figure 1. Final result Steps to apply Conditional Formatting in Excel Conditional formatting can be applied...
Discover How to Use the OR Function of Conditional Formatting
Conditional Formatting is an excellent way to visualize the data based on certain criteria. OR function in the Conditional Formatting highlights the data in the table if at least one of the defined conditions is met. This step by step tutorial will assist all levels of Excel users in creating...
1 2 5 6