Day 7 - Conditional Formatting
Formatting can help you analyze data by highlighting significant numbers or trends in the data. A conditional format applies formatting only when a cell’s value meets a specified condition. For example, a conditional format can make negative numbers red and positive numbers green. Conditional formats are dynamic, so a cell’s appearance will change to reflect its current value.
Case | ExterComp
Tom wants you to format a workbook that compares the sales of the X310 and X410 models during that time. The workbook has a documentation sheet, a Model comparison sheet comparing the total unit sold for each model in the eight sales regions, and a Monthly Sales sheet reporting the number of units sold per month.
In the Model comparison sheet, Tom wants you to highlight the sales regions that showed the greatest sales increases from 2008 to 2009.
In the Model comparison sheet, Tom wants you to highlight the sales regions that showed the greatest sales increases from 2008 to 2009.
Instruction File
|
Data File RequiredThe file on the left side is an instruction file. Click on Download File to open the file. Once opened, print a copy to get started. This particular assignment requires a data file to start. After printing the instruction file, go to the Data Files tab and open "X410" workbook to start.
If you're working in the classroom, you may find the Data File in the Share drive. |