How to Use VBA for Each Cell in a Range in Excel (3 Methods)

When working with large databases, dealing with ranges and cells is a common task. Sometimes, you need to perform the same action across a large ...

How to Apply Conditional Formatting to Multiple Columns in Excel – 10 Easy Methods

The sample dataset (B4:F9) contains names of employees, their projects and their working hours on different days. Method 1 - Use the ...

Highlighting Row with Conditional Formatting Based on Date in Excel

Here's the overview of the functions we'll use today and how they highlight cells or rows based on dates or ranges. We have a data table with ...

How to Apply Conditional Formatting Formula in Excel If Cell Contains Text (6 Methods)

  Method 1 - Highlight Cells Containing Any Text Select the cells where you want to apply conditional formatting. Go to the ...

How to Find Links in Excel ( 8 Suitable Approaches)

In this article, we will discuss 8 suitable approaches to find links in Excel. Excel has tremendous available options to link your working workbook ...

How to Highlight Cells Based on Text in Excel (2 Methods)

Highlighting cells with specific text in MS Excel is useful for easily finding matching text in datasets. Our sample dataset contains a list of ...

[Fixed!] Subscript Out of Range Error in Excel VBA

Here's an overview of VBA code that outputs errors. What Is the Subscript Out of Range Error in VBA? VBA Subscript out of range error ...

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 ...

Excel VBA to Highlight Specific Text in a Cell (6 Ways)

Download Practice Workbook VBA to Highlight Specific Text.xlsm We will use VBA codes to highlight specific text in the sample data set ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo