# Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

# Conditional Formatting

## Format Items Found in a List

| August 6, 2024 |

In this post, we’ll learn how to format a range to automatically highlight any items found in a list. In other words, we will learn how to highlight transactions that have a status value that matches any of the status values in a specific list, such as Pending or Processing. This illustration uses status values,…

## Formatting Condition is a Calculated Value

| July 30, 2024 |

Hello and welcome to this tutorial on how to use conditional formatting with a calculated value in Excel! Today, we’re going to dive into the following question: How do you conditionally format a cell when the condition is based on a calculated value? Let’s jump right in! Video Tutorial Let’s work through the concepts sequentially…

## Turn a Table of Events into a Graphical Calendar

| July 16, 2024 |

Today, we’re tackling the following question: How do you create a calendar that can show multiple events per day in Excel? We’re going to transform a simple table of events into a dynamic, graphical calendar. Let’s dive right in! Objective In summary, we have a list of events stored in a Table named Table1, like…

## Dynamic Conditional Formatting for Top 3 Values

| May 14, 2024 |

I recently received a question: “Can I format a cell based on another cell value, and have the formatting update automatically whenever the cell value changes?” Then answer is “yes” and this blog post demonstrates the steps. To illustrate the steps, we’ll dynamically highlight the top three scores in a list … and as the…

## Conditional Formatting With Data Validation

| March 12, 2024 |

In today’s Excel University blog post, we’re going to explore the incredible combination of the Conditional Formatting and Data Validation features in Excel. I was recently asked the following question: How do I highlight matching customers on one worksheet based on the customer selected in a data validation drop-down list on another? And I’ll answer…

## Excel How to Conditionally Format Variances

| March 5, 2024 |

Today, we’re diving into conditional formatting rules. Why? Well, to answer a question I received recently, which is basically: “I want a cell to be conditionally formatted based on the value in another cell where the criteria is: if cell C7 is up to 10% less than D7 then have a yellow color and if…

## Highlight Values Found Multiple Times

| February 27, 2024 |

Today, we’ll highlight recurring values within a dataset in order to answer a recent question. I was asked the following “I’m trying to get it to recognize if a specific letter, like X, is in a column at least three times. What could the formula look like?” And I’ll answer that question in this post.…

## Highlight Correct Answer with Conditional Formatting

| February 6, 2024 |

Time to walk through another exciting Excel adventure 🙂 Today, we’re zooming in on an interesting question I recently received: “How can I highlight correct answers on an Excel worksheet for my granddaughter’s multiplication tables?” Sounds like a marvelously practical application of Excel, doesn’t it? Well, let’s dive in and find out how we can…

## Dynamic Pivot-style Report with GROUPBY

| January 9, 2024 |

In this tutorial, we will learn how to use the GROUPBY function to create dynamic pivot-style reports with a single formula. Let’s back up a sec. For years, we’ve turned to PivotTables to build summary reports. Now we have another option: the GROUPBY function. While it doesn’t create a true PivotTable, it does create a…