MVP #11: Conditional Formatting in Excel to provide instant data insight

, , No Comments
Hello there!
In this Excel MVP post I will show you the cool use of conditional formatting to show instant data insight.

So let's use a fictitious data.
Company XYZ sells 4 products and have independent sales people working across the country. The company gives sales target to them and for the last evaluation period, a target of 700 sales per product was given. 
Below is the table of the sales achieved by the sales team, by person and by product.

So, how do you highlight the sales that met the target?
That's what conditional formatting does, and with easy and beauty.

This is not a beginner's class post, so I'll skip the explanations and just show you via screenshots how I did this.

If you have any question, please ask via the comment box.


Post a Comment

You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.