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.