Make Budgets in Excel with Expenditure Limit – Budget Ceiling using Data Validation ...
Budgets help control the expenditures even before they actually incur. The concept of budget is to provide a ceiling or cap to expenditures so...
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...
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...
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...
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...
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...
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....
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...