How to perform Conditional Formatting with formula in Excel

In this article, we will learn How to perform Conditional Formatting with formula in Excel. Why do we use conditional formatting to highlight c...

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

How to use Color Scale in Conditional Formatting

In this article, we’ll learn the use of Color scales option in conditional formatting. Also, answer questions like, why we use it in our reports and...

Embed Excel file into Word file

How to Insert an Excel document in Word file? In this article we will learn how we can embed the Excel file or insert the Excel table into word file....

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.