Category Archives for Conditional Formatting

How to Highlight Dates Between Two Dates

You have dates in column and you want to highlight all the dates which are between the range of two dates.Huh?OK, alright!Let’s say you have a start date 17-Jan-2017 and an end date 19-Mar-2017, and from the dates column, you want to highlight all the cells in which date is between these two dates.For this, […]

Excel Heat Map Template

An excel heat map template can help you present your data in with a strong message about the conclusion. It will also help you to add some extra power in your data.

Top 6 Examples of using Formulas in Conditional Formatting in Excel

The best part of conditional formatting is you can use formulas in it.It has a very simple sense to work with formulas. Your formula should be a logical formula and result should be in TRUE or FALSE.If that formula returns TRUE, conditional formatting will apply and if it returns FALSE, conditional formatting will not apply.The […]

How to Highlight Blank Cells in Excel

It’s hard to recognize blank cells in a large data. Because a blank cell is just a white cell without any value.In most of the cases, blank cells represent some sort of gap, missing data, or a formula returns an empty string resulting in a blank cell.And that’s why it’s recommended to highlight these cells […]

Apply Conditional Formatting to a Pivot Table

You know that pivot table is one of the most important tools to analyze and summarize data.You can create instant reports using pivot tables.And to make it more appealing to your users, you can apply conditional formatting to a pivot table.Just look at below where I have applied conditional formatting in a pivot table to […]