Introduction to Excel Formulas Conditional Formatting
Conditional formatting is a very powerful and fairly simple to use Excel feature; fairly simple, that is, after the extensive overhaul the user interface received in Excel 2007, which made it much simpler and easy to use.
Conditional Formatting allows you to change the format of a cell: background and foreground colors, fonts, and etcetera. This makes it much easier to find specific information in a large table; for example, finding the top or bottom percent of a range of values, finding duplicate values, or marking specific dates.
Top Hat Trick
Let’s see what the executives of the (fictitious) XYZ Widget company has dreamed up for us this time. The attached Excel file contains the monthly sales report for a few of the sales persons:
The V.P. want to see at a glance which are the three best sales persons. Reordering the lists is not an option as they should be kept in the same order for good unknown reasons (or so they claim). So, we’ll use conditional formatting to highlight the top three total sales cells. (more…)
Recently take over a job to give assignment to a group of people weekly. Instead of manual, I decided to automate it using Excel. Of course la, I’m IT guy and you know IT guy always lazy ma. 