Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.

Worth $20, Absolutely Free

Tag Archives for " Conditional formatting "

8 Examples for Using Formulas in Conditional Formatting

how to use formulas in conditional formatting featured image

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 […]

Check it out now

Highlight Blank Cells

how to highlight blank cells with conditional formatting featured image

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 […]

Check it out now

How To Use Conditional Formatting In Pivot Table [Examples]

Apply Conditional Formatting in Pivot Table By Using Slicer

You know that Pivot Table is one the most important tools to analyze data. And, Conditional Formatting is useful to deliver a strong message to the user along with data. Ahead of this post, you will learn about how you can combine these two awesome tools. You will learn to apply conditional formatting in pivot table.

Check it out now

How To Use Formulas In Conditional Formatting To Find New Customers From Data

Conditional Formatting is helping us from last 8 to 9 years. A well-designed Data Analysis & Presentation Tool created by Microsoft to enhance user experience. Everyone has a different way to work with Conditional Formatting. But, the good thing is that it is simple to use even it so powerful. In this post, I will use the formulas in conditional formatting to highlight new […]

Check it out now