Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Conditional Formatting is helping us from last 8 to 9 years. A well-designed Data Analysis & Presentation Tool created by Microsoft to enhance user experience. Everyone has a different way to work with Conditional Formatting. But, the good thing is that it is simple to use even it so powerful.
In this post, I will use the formulas in conditional formatting to highlight new customers in month’s sale data.
We have to start with a list of customer’s ID & name which is maintained from the start of the business. And, we have 26 customers in current month’s data.
We have to find old & new customers by using formulas in Conditional Formatting.
The formula used in conditional formatting in above example is verifying the count of customer ID from the master data. If the count equals to “0” then customer ID will be highlighted.
Apart from this, there are lots of wonderful things which are possible with the help of Conditional Formatting. So we will discuss all that later on.