Excel Basics Archives - Page 153 of 176

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

Apr 27, 2024

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

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

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

Nov 11, 2025

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

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

Conditional Formatting Based On Another Cell Range in Excel

Jul 5, 2024

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

Conditional Formatting Based On Another Cell Range in Excel

Excel Conditional Formatting Formula with IF

Apr 12, 2024

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

Excel Conditional Formatting Formula with IF

Excel Highlight Cell If Value Greater Than Another Cell (6 Ways)

Apr 30, 2024

Here's an overview of highlighting cells if they have higher values than other cells in a range. Highlight a Cell If Its Value Is Greater ...

Excel Highlight Cell If Value Greater Than Another Cell (6 Ways)

How to Remove Subtotals in Excel – 2 Methods

Aug 11, 2024

This is an overview. Method 1- Delete Subtotals from a List in Excel Steps: The following dataset contains subtotals. Select a ...

How to Remove Subtotals in Excel – 2 Methods

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

Jul 6, 2024

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

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

Conditional Formatting on Multiple Rows Independently in Excel

Jul 5, 2024

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

Conditional Formatting on Multiple Rows Independently in Excel

How to Compare Two Excel Sheets for Differences in Values

Aug 2, 2024

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 Compare Two Excel Sheets for Differences in Values

How to Remove Checkboxes from Excel: 6 Methods

Jul 6, 2024

Method 1 - Removing Checkboxes from Excel with Go To Command Steps: Go to Home >> Select Find & Select (in the Editing section) ...

How to Remove Checkboxes from Excel: 6 Methods

How to Check If a Cell Is Empty in Excel (7 Methods)

Jun 17, 2024

Method 1 – Using the ISBLANK Function Syntax: ISBLANK(value) Argument: value – This value will be tested. This may be empty or ...

How to Check If a Cell Is Empty in Excel (7 Methods)

Conditional Formatting Based on Multiple Values of Another Cell

Jul 6, 2024

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

Conditional Formatting Based on Multiple Values of Another Cell

How to Remove Numbers from a Cell in Excel (7 Effective Ways)

Jul 6, 2024

We have placed some Product Names and their IDs in the dataset. We want to remove the numbers from the Product IDs. Method 1 - Using Find ...

How to Remove Numbers from a Cell in Excel (7 Effective Ways)

Null vs Blank in Excel

Aug 7, 2024

While working with data in Microsoft Excel, you may encounter Null values or Blank cells. What Is Null in Excel? A null value in a cell ...

How to Check If Cell Is Empty Using Excel VBA: 5 Easy Methods

Jul 6, 2024

Method 1 - Using the VBA IsEmpty Function to Check If Cell Is Empty Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> ...