Conditional Formatting based on another cell

conditional formatting based on another cell

Learn how to make a rule dependent on the content of another cell using conditional formatting in Excel! So far, we have processed only and exclusively situations where the color of the given cell was specifically determined by the relationship of the values in a given range. What will happen if we would like to … Read more

Multiple Conditions (Conditional Formatting)

multiple conditions in excel 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

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 how to highlight duplicate rows in Excel using conditional formatting through useful examples! How to find duplicates You can use a few easy steps to find and highlight duplicate values in Excel. First, let us see how it works. 1. Select data, in this case, C2:E12 2. Click … Read more

Color Scales

color scales in excel

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 you take a deep dive, you should know: What is the difference between color scales and data bars? Data bars representing the relationship between value and colors … Read more

Icon Sets

icon sets excel

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

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

how to use quick analysis tool in Excel

Excel’s Quick Analysis Tool is the easiest way to analyze your data instantly using different tools (Formatting, Charts, Totals, Tables, or sparklines) In today’s lesson, we 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 … Read more