____________________________________________________________________________
Highlighting Rules
----------------------------------------------------------------------------
Rule_ _ _ _ _ _ _ _ _ _ _ _ _ _ Highlights
Greater Than_ _ _ _ _ _ _ _ _ Cell that are greater than a specified number
Less Than _ _ _ _ _ _ _ _ _ _ Cell that are less than a specified number
Between_ _ _ _ _ _ _ _ _ _ _ _Cells that are between two specified numbers
Equal To_ _ _ _ _ _ _ _ _ _ _ Cells that are equal to a specified number
Test That Contains_ _ _ _ _ _ Cells that contain specified text
A Date Occurring_ _ _ _ _ _ _ Cells that contain a specified date
Duplicate Values Cells that contain duplicate or unique values
____________________________________________________________________________
Case | Iowa
----------------------------------------------------------------------------
Kay Lewis is a political columnist, commentator, and blogger. Her website, Lewis Reports, contains historic information on campaigns and elections. Recently, Kay compiled state-by-state and county-by-county voting totals for the past 15 presidential elections. She wants this information in an Excel workbook so she can analyze voting preferences and trends. Kay has created a workbook that contains the election results from the 2004 presidential election in Iowa. She asks you to format the workbook. She wants formats that quickly show which candidates won the state and county levels as well as the margin of victory. Counties that went heavily Democratic or Republican should have formats that reflect this fact.
Click here to open and print out the instruction.
