Compare two lists for duplicates or unique values in no time using Excel
Last time we learnt a technique to compare two lists for similar values using conditional formatting. You can learn more about it at this...
Birth Dates Heat Map in Excel – How To
First off whoever has birthday on July the 7th my best wishes to all of them. You people have a very interesting birth date....
Formatting Numbers in Excel – Conditional Formatting Vs Custom Number Formatting
Accountants are always dealing with numbers. And its not always about highlighting positives. In some cases we have to make negative numbers standout and...
How to Highlight Blank Cells in Excel using Conditional Formatting [Quick Tip]
With huge data pinpointing blank cells is near to impossible. Sometimes back we learnt how to fill blank cells with zero using Go-To special...
Highlight every Nth row in Excel Tables – How To
By default, every second row in Excel tables is highlighted and the other option is to turn highlighting off completely. Though it does help...
Conditionally Format Chart’s Background in Excel – How To
Excel charting is in the air for last few weeks and we are learning some really cool tricks on making charts better looking and...
Comparing two columns to highlight Duplicates in the same row – Excel Conditional Formatting
Back to Excel after a long time. But now starting to relax a little as course is concluded for many subjects I teach. I...
Making Aging Analysis Reports Using Excel – How To
Aging analysis is helping accountants since ages and is one of those reports that are prepared mostly in Excel to track both receivables and...
How to LOOKUP using ONLY Conditional Formatting in Excel
Few days back we learnt how to do 2-way lookup i.e. looking up the value against two criteria. You can learn it in detail...
Conditional COUNT in Excel: Count cells meeting multiple criteria + Data Cleanup Tip
We have been provided with a top secret data of one lab situated at the very center of the earth. A team of vigilant...