## Conditional Formatting based on another cell

Learn how to use conditional formatting based on another cell and create a rule that depends on another cell value in Excel. Conditional formatting enables us to determine highlights based on the value of a referred cell. In the referred cell, we can modify the values arbitrarily. If the value changes, then the highlight of … Read more

## Multiple Conditions (Conditional Formatting)

Learn how to use multiple conditions and formulas in conditional formatting to apply multiple criteria (AND, OR, LEFT, RIGHT) to a single cell or a range. Now let’s talk about the logical functions. In this section, we’ll show you how to create effective formulas to build a complex rule. First, we will create a new … Read more

## Color ranking

Learn how to combine the Excel RANK function to determine the sorting order using colors.

## Stop If True

How to use the Stop If True rule in Excel to ignore the other rules?

## Multiple Rules Hierarchy

Using multiple rules in Excel conditional formatting is not rocket science. Learn how the rules hierarchy and overlapping are works. If you are not familiar with the hierarchy and rules overlapping, this article is yours! What is this mean? The rules are subordinate to each other. Is more rule applying to one cell than Excel … Read more

## Find Duplicates

Learn how to find duplicate values and highlight duplicate rows in Excel using conditional formatting through useful examples! How to find duplicates in Excel You can use a few easy steps to find and highlight duplicate values in Excel. But, first, let us see how it works. 1. Select data, in this case, C2:E12 2. … Read more

## Color Scales

Color scales in Excel are similar to Data Bars. Get a quick overview of your data! The shade of the color represents the value in the cell. Before taking a deep dive, you should know: What is the difference between color scales and data bars? Data bars represent the relationship between value and colors through … Read more

## Icon Sets

Icon sets in Excel are effective tools for us to visualize values in a range of cells easily. Each icon represents a range of values. If you want to add an icon set, shape, or indicator, execute the following steps. Steps to add Icons sets We will use traffic light style shapes: green, yellow, and … Read more

## Data Bars

Data bars in Excel make it easy to highlight values in a range of cells. A longer bar represents a higher value. A shorter in-cell bar chart represents a lower value. Get a quick overview of highs and lows! If you’re not using specific rules or conditions in your data range or cells, then data … Read more

## Quick Analysis Tool

Excel’s Quick Analysis Tool is the easiest way to analyze your data instantly using different tools (Formatting, Charts, Totals, Tables, or sparklines) Today’s lesson will explain how to use this feature in Excel. Table of contents: How to turn on the Quick Analysis feature Formatting Ranges using Quick Analysis Tool Inserting charts using QAT Quick … Read more