Using Conditional Formatting to highlight range of percentages in Excel
With conditional formatting feature, Excel makes even the numeric bits easy to understand with visual aids. Conditional formatting lets you format the cell and...
FREE Excel Invoice Template V1.0 with Customer and Product list – Unlocked + Download...
Everyone loves getting paid but to get paid one needs to send invoice and to make an invoice that is not only effective from...
ABC Analysis using Conditional Formatting in Excel
ABC analysis is an inventory management technique in which stock is classified in usually three categories on the basis of their importance. Such classification...
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...
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 Excel errors in the worksheet using Conditional Formatting [Quick Tip]
In my last Excel article I discussed different types of errors we can run into while working in Excel with reasons and solutions to...
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...
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...
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...
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...