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 here: How to do 2 Way Lookup in Excel – One...
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 correct them. I strongly recommend reading Understanding, Detecting and Correcting Excel...
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 help management to concentrate their efforts on such products that...
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 individuals take readings of different parameters to monitor the temperature...
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 most often but often times we may find a need...
10+ ways to make Excel Variance Reports and Charts – How To
Whether it is daily life thing or any day at work, we are always comparing to see whats good and what is not so good. This differential analysis has a much popular name as variance...
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. 7 and 7. Everyone's birthday is interesting in one or...
Create Edgy To-Do or Checklists with Check boxes in Excel + Shortfall calculator
The ones who like to plan adores to-do lists as well. And if you are also the one who likes to strike a line or tick or dash or mark then this tutorial is...
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 having a negative sign is just not enough. Similarly 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 page.
However the formula we employed had its limitations as it...