When we released Excel 2010 we published a workbook for you to downloadcontains examples of conditional formatting rules. The examples are very helpful for learning how to track trends, status, site data check and find top values.
But explain not only abstract examples of conditional formatting; rules the rules apply to real Situationen--some for business and some just for fun. Find out how you compare bikes by using a rating scale; Calculation of sales for a specific region and destination; Compare heights of the highest mountains by data bars; Identify certain numbers, data and text in a list of products, and much more.
Here are the rules in the workbook:
Mobile phone value:Numbers, data, and text in a list of products identifying certain mobile phone value (with formula): identify a dynamically changed number or text value in a list of products of top/bottom values: determine which are the top two students in the classabove/below the average: upper/lower values identify, above, below, and on average values in a recently published report by the book-tour : determine, who are the best two students in the class unique/duplicate: find duplicate rows in a list of customers icon set: quickly see revenue status and trends from one quarter to the next icon set: compare different product criteria by using a rating scale icon set: examine profit trends from month to month icon set: identify regional sales under $900,000 data bars: heights of the highest mountains of compare 3 color chart: distribution in major product categories examining total sales formula-based: shade alternate rows in a range -formula-based: compare data in a cell outside the conditionally formatted cells -formula-based: shade an entire row where several criteria must be true formula-based: shade an entire row if the row is a unique value