Highlight Row with Bottom 3 Values with a Criteria

We highlight cells in excel so that we can easily identify the focus areas on data. Formatting of cells in excel is also done for visualising data v...

9 Reason to Learn Excel Functions

In any department of any organization, Excel plays an integral part of data management, analysis, representation, etc. Be it the owner of an MNC or a ...

What is an Excel Helper Column?

An Excel helper column is an extra column added to the data only for simplifying some calculations or analyses. A helper column is often used in Ex...

Excel Conditional Formatting Based on Another Column

There will be times when you would want to format cell or column based on another column's value. Maybe this is that time for you. That's why you are ...

Highlight Bottom 3 Values in Excel

In data analysis and MIS reporting, we often get the need to highlight the top and bottom values. This helps us to easily identify focus areas. In t...

Validate only uppercase in data validation

In this article, we will learn how to validate only uppercase text entries in Excel 2016. Problem: Here we have a task where only uppercase ...

Highlight Cell if Cell in Other Columns are Blank

In this article, I will explain how you can format a cell if cell/s are blank in other columns. To understand this conditional formatting in excel let...

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.