Conditional Formatting

To navigate to the worksheet you want to see, click the worksheet name button in the Wo

To return to this Home worksheet, click the Home button in the top left ce Worksheet

Rule Type Cell value Cell value (with formula) T Top/bottom values Unique/duplicate Icon set Icon set Icon set Icon set Data bars 3 color scale Formula-based Formula-based Formula-based Formula-based

u want to see, click the worksheet name button in the Worksheet column.

Home worksheet, click the Home button in the top left cell. Description Find specific numbers, dates, and text in a list of products See a dynamically changed number or text value in a list of products Identify top, bottom, and above average values in a recent book tour report Determine who are the top two students in the class Find duplicate rows in a list of customers Quickly see revenue status and trends from one quarter to the next Compare different product criteria by using a rating scale Examine profit trends from month to month Identify regional sales below $900,000 Compare heights of the tallest mountains Examine overall sales distributions in key product categories Shade alternate a rangethe conditionally formatted range Compare data inrows a cellinoutside of cells Shade an entire row where several criteria must be true Shade an entire row if the row is a unique value

Date

Product Region Amount ### Dairy Denmark ### ### Produce Denmark ### ### Produce Denmark ### Denmark Total ### ### Dairy Finland $192.10 ### Dairy Finland $351.00 ### Grain Finland $560.40 Finland Total ### ### Dairy Germany $470.00 ### Dairy Germany $17.40 ### Grain Germany ### ### Grain Germany $470.00 ### Grain Germany $17.40 ### Grain Germany $747.00 ### Produce Germany $17.40 ### Produce Germany $747.00 Germany Total ### ### Dairy Italy ### ### Dairy Italy $438.43 ### Produce Italy ### ### Produce Italy $438.43 Italy Total ###

Date

Product Region Amount ### Dairy Denmark ### ### Produce Denmark ### ### Produce Denmark ### Denmark Total ### ### Dairy Finland $192.10 ### Dairy Finland $351.00 ### Grain Finland $560.40 Finland Total ### ### Dairy Germany $470.00 ### Dairy Germany $17.40 ### Grain Germany ### ### Grain Germany $470.00 ### Grain Germany $17.40 ### Grain Germany $747.00 ### Produce Germany $17.40 ### Produce Germany $747.00 Germany Total ### ### Dairy Italy ### ### Dairy Italy $438.43 ### Produce Italy ### ### Produce Italy $438.43 Italy Total ###

Change Product: Grain Change Amount:

$200

4

(Top 20%)(Above Average) (Bottom 10)

City Date Fee Attendance Books Anchorage 15-Mar $1,038 179 Atlanta 8-Feb $1,880 149 Boston 25-Jan $821 385 Charleston 29-Jan $1,822 328 Cleveland 10-Feb $1,073 128 Detroit 14-Feb $1,881 376 Flagstaff 25-Mar $1,222 37 Los Angeles 5-Mar $945 265 Memphis 6-Feb $910 93 New Orleans 31-Mar $1,233 415 New York 23-Jan $1,180 205 Philadelphia 31-Jan $1,965 145 Phoenix 23-Mar $955 37 Portland 9-Mar $781 85 Providence 2-Feb $1,964 111 Salt Lake City 21-Mar $1,190 275 San Francisco 7-Mar $904 171 Seattle 11-Mar $936 279 St. Louis 18-Feb $926 354 Topeka 20-Feb $1,775 66 Vancouver, B.C. 13-Mar $1,740 69 Washington, D.C. 27-Jan $1,724 499

Sold 98 95 146 124 32 58 5 47 45 59 147 31 8 33 73 37 145 109 19 12 59 151

Student Quiz1 Exam1 Quiz2 Exam2 Grade Nancy 96 97 90 82 Andrew 59 55 71 94 Janet 69 71 98 98 Margaret 99 90 59 79 Steven 56 86 65 74 Michael 57 61 84 67 Robert 55 86 59 86 Laura 89 91 91 81 Anne 55 77 91 86

90 72 84 83 75 66 79 87 79

Contact Name Address City Postal Code Country Ana Trujillo Avda. de la Constitución México 2222 D.F.5021 Mexico Antonio Moreno Mataderos 2312 México D.F.5023 Mexico Christina Berglund Berguvsvägen 8 Luleå S-958 22Sweden Frédérique Citeaux 24, place Kléber Strasbourg 67000 France Thomas Hardy 120 Hanover Sq. London WA1 1DPUK Georg Pipps Geislweg 14 Salzburg 5020 Austria Guillermo FernándezCalle Dr. Jorge Cash México 321 D.F.5033 Mexico Hanna Moos Forsterstr. 57 Mannheim 68306 Germany Henriette Pfalzheim Mehrheimerstr. 369 Köln 50739 Germany Henriette Pfalzheim Mehrheimerstr. 369 Köln 50739 Germany Horst Kloss Taucherstraße 10 Cunewalde 1307 Germany Isabel de Castro Estrada da saúde n. Lisboa 58 1756 Portugal Maria Anders Obere Str. 57 Berlin 12209 Germany Marie Bertrand 265, boulevard Charonne Paris 75012 France Hanna Moos Forsterstr. 57 Mannheim 68306 Germany Sergio Gutiérrez Av. del Libertador 900 Buenos Aires 1010 Argentina Thomas Hardy 120 Hanover Sq. London WA1 1DPUK Maria Anders Obere Str. 57 Berlin 12209 Germany Thomas Hardy 120 Hanover Sq. London WA1 1DPUK

Phone (5) 555-4729 (5) 555-3932 0921-12 34 65 88.60.15.31 (171) 555-7788 6562-9722 (5) 552-3745 0621-08460 0221-0644327 0221-0644327 0372-035188 (1) 356-5634 030-0074321 (1) 42.34.22.66 0621-08460 (1) 123-5555 (171) 555-7788 030-0074321 (171) 555-7788

1-12 34 65

1) 555-7788

1-0644327 1-0644327 2-035188

-0074321 42.34.22.66

1) 555-7788 -0074321 1) 555-7788

2 005 2006 Gross Profits (in Millions) Area Q4 Q1StatusTrend Q2StatusTrend Q3StatusTrend Q4StatusTrend Europe $32### 33 1 ### 81 $48### 72 -9 ### 56 -16 S. America $26### 29 3 ### 30 $1 ### 42 12 ### 69 27 Far East $49### 62 13 ### 70 $8 ### 43 -27 ### 63 20 Australia $22### 64 42 ### 78 $14### 38 -40 ### 45 7 N. America $11### 67 56 ### 77 $10### 35 -42 ### 76 41

5

4

3

2

Product

Shifting

Brakes

Handle Bars

Mountain Bike Comfort Rider Hybrid Road Bike Recumbant Unicycle

5 4 3 3 2 3

1 3 3 1 3 2

1 3 3 1 3 2

1

Seat 2 5 3 2 4 1

Frequen Overall cy Score of Repair 3 2.4 4 3.8 2 2.8 1 1.6 2 2.8 5 2.6

FY 2008 July August September October November December January February March April May June

Profits $5,000 $7,000 $10,000 $2,500 $4,000 $9,800 $5,400 $6,700 $4,300 $11,000 $12,500 $9,800

Trend $2,000 $3,000 -$7,500 $1,500 $5,800 -$4,400 $1,300 -$2,400 $6,700 $1,500 -$2,700

Region NorthWest West SouthWest South Central NorthEast East Territories Total

< $900,000 Sales $1,781,345 $534,389 $1,009,268 $899,999 $2,345,184 $900,000 $1,567,090 $34,678 $9,071,953

Height Default Percent (m) Value Aconcagua Argentina 6,960 6,960 6,960 Annapurna I Nepal 8,078 8,078 8,078 Ararat Turkey 5,122 5,122 5,122 Citlaltepetl Mexico 5,700 5,700 5,700 Cook New Zealand 3,764 3,764 3,764 Everest Nepal-China 8,848 8,848 8,848 Grand Teton Wyoming, U.S.4,196 4,196 4,196 Huascaran Peru 6,768 6,768 6,768 Jaja New Guinea 5,029 5,029 5,029 Jebel ToubkalMorocco 4,164 4,164 4,164 K2 Kashmir 8,611 8,611 8,611 KanchenjungaIndia-Nepal 8,598 8,598 8,598 Kilimanjaro Tanzania 5,895 5,895 5,895 Kinabalu Malaysia 4,101 4,101 4,101 Logan Yukon, Canada 6,050 6,050 6,050 McKinley Alaska, U.S. 6,194 6,194 6,194 Mont Blanc France-Italy 4,807 4,807 4,807 Monte Rosa Italy-Switzerland 4,634 4,634 4,634 Ojos del Salado Argentina-Chile 6,880 6,880 6,880 Ras Dashan Ethiopia 4,260 4,260 4,260 Sajama Bolivia 6,520 6,520 6,520 Vinson MassifAntarctica 5,140 5,140 5,140 Mountain

Location

PercenBar only tile 6,960 6,960 8,078 8,078 5,122 5,122 5,700 5,700 3,764 3,764 8,848 8,848 4,196 4,196 6,768 6,768 5,029 5,029 4,164 4,164 8,611 8,611 8,598 8,598 5,895 5,895 4,101 4,101 6,050 6,050 6,194 6,194 4,807 4,807 4,634 4,634 6,880 6,880 4,260 4,260 6,520 6,520 5,140 5,140

Two column bar chart 6,960 6,960 8,078 8,078 5,122 5,122 5,700 5,700 3,764 3,764 8,848 8,848 4,196 4,196 6,768 6,768 5,029 5,029 4,164 4,164 8,611 8,611 8,598 8,598 5,895 5,895 4,101 4,101 6,050 6,050 6,194 6,194 4,807 4,807 4,634 4,634 6,880 6,880 4,260 4,260 6,520 6,520 5,140 5,140

Country RegionDairy ProduceGrain Beverage Total Sales Finland North ### ### ### $19,474 ### Finland South ### ### ### $16,734 ### Spain North ### ### ### $45,120 ### Spain South ### ### ### $60,116 ### France East ### ### ### $21,991 ### France West ### ### ### $31,810 ### Norway North ### ### ### $19,191 ### Norway South ### ### ### $47,141 ### DenmarkEast ### ### ### $56,706 ### DenmarkWest ### ### ### $47,036 ### Italy Mid ### ### ### $64,064 ### Italy South ### ### ### $32,748 ### GermanyEast ### ### ### $26,952 ### GermanyWest ### ### ### $15,132 ### UK North ### ### ### $56,741 ### UK South ### ### ### $49,805 ### Belgium North ### ### ### $29,043 ### Belgium Mid ### ### ### $52,787 ### Sweden Mid ### ### ### $10,731 ### Sweden South ### ### ### $60,148 ###

Widgets Whatnots Whoseits Account #Actuals Budget Variance Actuals Budget Variance Actuals Budget Variance VF-56 ### ### 58% ### ### 26% ### ### 4% NA-16 $17,911 ### -93% ### ### 67% ### $67,530 1032% YI-31 $45,016 ### -65% ### ### -15% ### ### 290% CF-33 ### $84,668 417% ### ### -64% ### ### -61% AT-38 ### ### -12% ### ### 9% ### ### 264% IR-59 ### ### -57% ### ### -62% ### ### 334% SP-95 ### ### 325% ### ### 138% ### ### -40% GT-96 ### ### -6% ### ### -21% ### ### -2% AQ-18 ### ### -24% ### ### -87% ### ### 319% LX-84 ### ### 12% ### ### 149% ### ### 23% BG-53 ### ### -11% ### ### -18% ### ### 172% DF-84 ### ### 241% ### ### -31% ### ### -14% MM-33 ### ### -63% $31,254 ### -96% ### $70,813 1147% VZ-105 ### ### 1% ### ### 101% ### ### 69% YS-39 ### ### -31% ### ### -73% $58,487 ### -91% TO-55 ### ### -15% ### $21,385 2493% ### ### 44% WF-69 ### ### 49% ### $38,483 1297% $57,354 ### -93% VA-41 ### ### -66% ### ### 4% ### ### 33% OL-94 ### ### 126% ### ### 97% ### $16,835 5190% TL-14 ### ### 4% ### ### -49% ### ### 228% XZ-75 ### ### 18% ### ### -18% ### ### 98% BC-92 ### ### -20% ### $26,499 1551% ### ### -42%

Variance

Division North East South West Division North East South West Division North East South West

Q1 A $55 $59 $60 $90 B $47 $89 $61 $54 C $76 $81 $85 $56

Q2

Q3

Q4 Totals

$40 $98 $46 $65

$55 $76 $86 $82

$70 $90 $78 $45

$220 $323 $270 $282

$81 $63 $49 $64

$54 $71 $88 $91

$61 $58 $86 $73

$243 $281 $284 $282

$45 $62 $62 $72

$78 $47 $82 $72

$92 $59 $83 $89

$291 $249 $312 $289

Q1 Division A North $52 East $59 South $60 West $90 Division B North $53 East $89 South $61 West $54 Division C North $76 East $81 South $85 West $56

Q2

Q3

Q4 Totals

$88 $89 $46 $65

$52 $76 $86 $82

$70 $262 $90 $78 $45

$66 $63 $49 $64

$54 $71 $88 $91

$61 $58 $88 $73

$45 $62 $64 $72

$78 $47 $82 $72

$92 $59 $83 $89

Date

Product Region Amount ### Dairy Denmark ### ### Produce Denmark ### ### Produce Denmark ### Denmark Total ### ### Dairy Finland $192.10 ### Dairy Finland $351.00 ### Grain Finland $490.50 Finland Total ### ### Dairy Germany $470.00 ### Dairy Germany $17.40 ### Grain Germany ### ### Grain Germany $470.00 ### Grain Germany $17.40 ### Grain Germany $447.00 ### Produce Germany $17.40 ### Produce Germany $747.00 Germany Total ### ### Dairy Italy ### ### Dairy Italy $438.43 ### Produce Italy ### ### Produce Italy $438.43 Italy Total ###

Contact Name Address City Postal Code Country Phone # T/F Christina BerglundBerguvsvägenLuleå 8 S-958 22 Sweden 0921-12 34 65 1 Hanna Moos Forsterstr. 57 Mannheim 68306 Germany 0621-08460 2 Henriette Pfalzheim Mehrheimerstr. Köln 369 50739 Germany 0221-0644327 2 Maria Anders Obere Str. 57 Berlin 12209 Germany 030-00743212 Sergio Gutiérrez Av. del Libertador Buenos 900Aires 1010 Argentina(1) 123-55551 Thomas Hardy 120 Hanover Sq. London WA1 1DP UK (171) 555-7788 3 Marie Bertrand 265, blvd. Charonne Paris 75012 France (1) 42.34.22.66 1 Thomas Hardy 120 Hanover Sq. London WA1 1DP UK (171) 555-7788 3 Antonio Moreno Mataderos 2312 México D.F.5023 Mexico (5) 555-39321 Maria Anders Obere Str. 57 Berlin 12209 Germany 030-00743212 Isabel de Castro Estrada da saúde Lisboa n. 58 1756 Portugal (1) 356-56341 Guillermo Fernández Calle Dr. JorgeMéxico Cash 321 D.F.5033 Mexico (5) 552-37451 Frédérique Citeaux 24, place Kléber Strasbourg67000 France 88.60.15.31 1 Thomas Hardy 120 Hanover Sq. London WA1 1DP UK (171) 555-7788 3 Horst Kloss TaucherstraßeCunewalde1307 10 Germany 0372-0351881 Georg Pipps Geislweg 14 Salzburg 5020 Austria 6562-9722 1 Hanna Moos Forsterstr. 57 Mannheim 68306 Germany 0621-08460 2 Henriette Pfalzheim Mehrheimerstr. Köln 369 50739 Germany 0221-0644327 2

1 0 0 0 1 0 1 0 1 0 1 1 1 0 1 1 0 0