Excel Basics

Highlighting Row with Conditional Formatting Based on Date in Excel

In this article, I am going to show you how to highlight rows with Conditional Formatting Based on Date in Excel. If you are looking for some of the ...

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

Excel conditional formatting formula if a cell contains text means highlighting those cells that contain any text value or specific text value by ...

Excel Conditional Formatting for Dates Within 30 Days

Conditional formatting has made it easy to highlight important cells or ranges of cells, emphasize unusual values, and visualize data, color scales, ...

How to Apply Conditional Formatting for Blank Cells in Excel

While working with a large number of data, numerous blank cells in your dataset is a common scenario. As a result, it can misinterpret your dataset ...

How to Apply Conditional Formatting to the Selected Cells in Excel

Conditional Formatting is a versatile and flexible tool embedded in Excel that enables us to modify and format cells based on various conditions. ...

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

Conditional Formatting Based On Another Cell Range in Excel

If you are looking for some of the easiest ways to do Conditional Formatting based on another cell range in Excel, then you are in the right place. ...

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

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

To compare any particular product price, availability, etc. in different times or seasons the greater than operator helps us. In this article, I’m ...

How to Remove Subtotals in Excel (2 Easy Tricks)

In this article, we will discuss two easiest methods to remove subtotals in Excel. Basically, we use the subtotal option in excel to organize and ...

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

While dealing with a huge database you may need to change the row color of some specific cells based on a text value to identify them quickly. Excel ...

Conditional Formatting on Multiple Rows Independently in Excel

Conditional Formatting is one of the essential tools in Microsoft Excel. Analyzing data, creating insights, and other things that we can do using ...

How to Compare Two Excel Sheets for Differences in Values

When we have two versions of the same workbook, the first thing that crosses our mind is to compare them and find the differences in values between ...

How to Remove Checkboxes from Excel (6 Ways)

Often, we use checkboxes in Excel to demonstrate our task status and many more. In this article, we discuss how to remove check boxes from Excel. In ...

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

Microsoft Excel is one of the most popular applications used for official and business purposes. Further, as an analyst, we look out whether a cell ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo