How to Highlight Dates in Next 30 or N days in Excel

To highlight dates that are coming in the next N days from today, we will use conditional formatting of Excel. The generic formula in conditiona...

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

Select and Copy only Non-Blank Ranges in Excel

Sometimes we get data in Excel from External sources. These data may not be in an ordered format, they may contain blank rows that you don't need. In ...

Highlight Row Base on A Cell Value in Excel

Earlier we learned how to highlight entire if any cell in row contains specific text. In this article, we will learn how to highlight row if cell in a...

How to use the QUOTIENT function in Excel

In this article, we will learn about how to use the QUOTIENT function function in Excel. The QUOTIENT function is a mathematical division function ...

How To Highlight Row in Excel if Row Contains Specific Text

Sometimes, we want to highlight the row that contains the specific text. In this article, we will learn how to highlight a row, if any cell in that ro...

Highlight cells that contain specific text

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

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