How to Highlight cells that contain specific text in Excel

In this article, we will learn about how to Highlight cells that contain specific text using Conditional formatting option in Excel. Conditional Form...

Perform Conditional formatting based on another cell value in excel

In this article, we will learn about how to use Conditional formatting based on another cell value in Excel. In simple words, We need to view highl...

How to perform Conditional Formatting with formula 2016

In this article, we will learn about how to use formula in Conditional formatting option. Conditional Formatting is used to highlight the data on t...

Prevent Duplicate Entries in a Range with Excel Data Validation

In this article, we will learn how to prevent duplicate entries in a range with Data Validation. We will learn how helpful and useful this feature is...

How to Create Dynamic Drop Down List in Excel Using 4 Different Methods

In this article, we will learn how to create dynamic drop down list in Microsoft Excel. As we know Data Validation feature improves the efficiency of...

How to create Drop Down list with Data Validation in Excel

In this article, we will learn how to create drop down list using data validation in Microsoft Excel. Data Validation feature improves the efficiency...

How to Create Dependent (Cascading) Drop Down List in Excel Using 5 Different Techniques

So far in this Data Validation series, we have learnt to create normal drop down list and dynamic drop down list using different techniques with data ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube