Get instant access to this free e-book fully loaded with Useful Excel Tips, 80+ Keyboard Shortcuts, and VBA Codes.
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
It’s hard to recognize blank cells from a large data table. Because a blank cell is just a white cell without any value. In most of the cases, blank cells represent some sort of gap or missing data. It’s recommended to highlight these cells with a color so that we can recognize them. And, I found that […]Check it out now
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
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