Excel Formulas

How to Highlight Row Using Conditional Formatting (9 Methods)

When you are working with a large database you may want to highlight some specific rows based on other cells or values to identify them quickly. In ...

How to Conditional Format for Dates Within 30 Days in Excel (3 Methods)

The below dataset has 3 columns displaying Order ID, Date, and Amount. Method 1 – Conditional Formatting for Dates within 30 Days for Dates in a ...

How to Compare 4 Columns in Excel (6 Methods)

Method 1 – Using Conditional Formatting  Steps: Select the cells of 4 Columns from the dataset. Go to the Home tab. Select the ...

How to Apply Conditional Formatting to Blank Cells in Excel – 2 Methods

This is an overview: This is the sample dataset.   Method 1 - Using the Conditional Formatting Command  This is the ...

How to Apply Conditional Formatting to the Selected Cells in Excel

We will be using a Product Price List dataset to demonstrate applying conditional formatting in Excel. Method 1 - Using Highlight Cells ...

Conditional Formatting Multiple Text Values in Excel (4 Easy Ways)

Consider a dataset of Product Sales, where we have text value columns named Region, City, Category, and Product. We want to conditionally format the ...

How to Use Conditional Formatting Based on VLOOKUP in Excel (3 Criteria)

In this article, you learn how to apply Conditional Formatting based on the VLOOKUP function with 3 different criteria in Excel. How to Use ...

Conditional Formatting Based On Another Cell Range in Excel

Here's an overview of using Conditional Formatting based on another cell range. We have two data tables. The first table has Sales values for ...

Excel Conditional Formatting Formula with IF

Method 1 - Simple Conditional Formatting Formula with IF in Excel Consider a sample dataset of Products with their purchase and sold amounts. You ...

How to Change Row Color Based on Text Value in Cell in Excel

We'll use the following simple dataset to showcase how to change row colors based on text values inside cells. Change the Row Color Based ...

Conditional Formatting on Multiple Rows Independently in Excel

Method 1 - Use of the Conditional Formatting Command for Multiple Rows Steps ① Select the range of cells D5:F10. ② From the Home tab, go ...

How to Compare Two Excel Sheets for Differences in Values

Here, we have used the view side-by-side command to compare two Excel sheets to find the differences in values. How to Compare Two Excel ...

How to Check If a Value Is in List in Excel (10 Ways)

Consider a dataset about some products of a company. We will check whether specific values in the Product column exist. Method 1 - Using ...

How to Remove Leading Space in Excel (5 Useful Ways)

Sometimes there may be some extra spaces at the front of your data in Excel and you may need to remove these extra leading spaces to use this data. ...

Conditional Formatting Based on Multiple Values of Another Cell

Method 1 - Conditional Formatting on a Single Column Based on Multiple Values of Another Cell Step 1: Select Column and Open Conditional Formatting ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo