Conditional formatting based on another cell value

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

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

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

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 Google PlusVisit Us On Youtube