Consider the data presented in Figure 1; sales data is presented for each of thirteen salespersons.
You have been charged with the responsibility of creating a chart containing this data and also having the top-performing salesperson’s data as well as the bottom-performing salesperson’s data formatted differently than the rest of the data on the chart.
There's no Excel 2003 (.xls) solution in this article for holidays.
The original calendar is a simple monthly matrix that uses a conditional formatting rule to highlight the weekends.
By separating the year, month, and day, you can reuse the same sheet.
This month, we'll add a rule that highlights holidays.
In that file, you'll find three sheets: This technique relies on the NETWORKDAYS() function, which is available in Excel 2007 and later versions.
Conditional formatting is a great tool for automatically formatting data in Excel, based on the conditions present in a cell(s).
For example, we can use conditional formatting to highlight, automatically, all unfavorable budget variances in red and all favorable budget variances in blue.
(On the Home tab, click Conditional Formatting, and then click Manage Rules.) When two or more conditional formatting rules apply to a range of cells, these rules are evaluated in order of precedence (top to bottom) by how they are listed in this dialog box.
Here's an example that has expiration dates for ID badges.