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 "

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

➲ Continue Reading

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

➲ Continue Reading

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

➲ Continue Reading