Topics to be covered in Sheet 1(Sales Data)
Highlight cells that are greater than $4000.
Data Bars are horizontal bars added to each cell, much like a bar graph.
Color Scales change the color of each cell based on its value. Each color scale uses a two- or three-color gradient. For exam
Top/Bottom Rules are premade types of conditional formatting in Excel used to change the appearance of cells in a range base
Click Manage Rules to edit or delete individual rules. This is especially useful if you've applied multiple rules to a worksheet.
Clear Rules
hree-color gradient. For example, in the Green-Yellow-Red color scale, the highest values are green, the average values are yellow, an
arance of cells in a range based on your specified conditions
multiple rules to a worksheet.
average values are yellow, and the lowest values are red.
Sales Data
Salesperson May June July August September
Albertson, Kathy $3,799.00 $557.00 $3,863.00 $1,117.00 $8,237.00
Allenson, Carol $18,930.00 $1,042.00 $9,355.00 $1,100.00 $10,185.00
Altman, Zoey $5,725.00 $3,072.00 $6,702.00 $2,116.00 $13,452.00
Bittiman, William $1,344.00 $3,755.00 $4,415.00 $1,089.00 $4,404.00
Brennan, Michael $8,296.00 $3,152.00 $11,601.00 $1,122.00 $3,170.00
Carlson, David $3,945.00 $4,056.00 $3,726.00 $1,135.00 $8,817.00
Collman, Harry $8,337.00 $4,906.00 $9,007.00 $2,113.00 $13,090.00
Counts, Elizabeth $3,742.00 $521.00 $4,505.00 $1,024.00 $3,528.00
David, Chloe $7,605.00 $3,428.00 $3,973.00 $1,716.00 $4,839.00
Davis, William $5,304.00 $1,562.00 $2,945.00 $1,176.00 $9,642.00
Dumlao, Richard $9,333.00 $2,779.00 $7,549.00 $1,101.00 $5,850.00
Farmer, Kim $1,103.00 $3,470.00 $3,862.00 $1,040.00 $10,024.00
Ferguson, Elizabeth $1,333.00 $1,913.00 $4,596.00 $1,126.00 $5,503.00
Flores, Tia $12,398.00 $2,883.00 $2,142.00 $2,014.00 $13,547.00
Ford, Victor $3,251.00 $4,931.00 $8,283.00 $1,054.00 $9,543.00
Hodges, Melissa $4,624.00 $4,798.00 $8,420.00 $1,389.00 $10,468.00
Jameson, Robinson $2,552.00 $4,459.00 $2,248.00 $1,058.00 $6,267.00
Kellerman, Frances $4,281.00 $4,172.00 $11,074.00 $1,282.00 $2,365.00
October
$8,690.00
$18,749.00
$8,046.00
$20,114.00
$10,733.00
$18,524.00
$13,953.00
$15,275.00
$13,085.00
$13,714.00
$15,065.00
$18,389.00
$10,686.00
$21,983.00
$11,967.00
$12,677.00
$14,982.00
$9,380.00
First Quart
Student Name Unit 1 Quiz 1 Unit 1 Test Unit 2 Quiz 1
Jackson Love 70 75 88
Priya Patel 97 100 92
Sharia Clemmons 95 97 45
Ming Lu 91 93 89
Sadie Carter 86 84 93
Jensen Howard 54 70 87
Tyriq Hilton 77 85 76
Maria Saldana 100 96 93
Kyle Jacobs 90 89 91
John Feinstein 89 67 84
Carter Zhou 75 68 82
Jose Marco Hernandez 93 87 86
Betsy Michaels 90 95 80
Dexter Cooper 62 71 76
Quanisha Johnson 100 98 86
1 Select cells B3:J17.
2 Apply Conditional Formatting
3 Conditional Formatting
4 Using the Manage Rules fe
rst Quarter Grades
Unit 2 Quiz 2 Unit 2 Test Unit 3 Quiz 1 Unit 3 Test
90 72 69 75
95 96 68 95
79 83 95 94
95 97 84 85
89 94 77 88
72 85 65 74
90 68 72 78
87 88 87 92
93 94 88 95
87 85 80 90
83 85 84 66
91 93 95 82
73 76 71 88
84 80 85 87
89 93 95 96
3:J17.
nal Formatting so it Highlights Cells containing values
rmatting tab, select the Icon Set called 3 Symbols (Circled)
nage Rules feature, remove the light red fill, but keep
1st Quarter Project Midterm
93 85
92 93
100 92
88 99
87 86
94 70
94 87
95 95
88 95
93 95
50 68
99 85
85 77
93 68
97 92
ning values Less Than 70 with a light red fill.
mbols (Circled).
t red fill, but keep the icon set.
Bulbas Grass 45
Ivysaur Grass 60
VenusaGrass 80
Charm Fire 65
Charm Fire 80
CharizaFire 100
Squirtl Water 43
WartorWater 58
Blastoi Water 78
Name
Bulbasaur
Ivysaur
Venusaur
Charmander
Charmeleon
Charizard
Squirtle
Wartortle
Blastoise
Caterpie
Metapod
Butterfree
Weedle
Kakuna
Beedrill
Pidgey
Pidgeotto
Pidgeotto
Rattata
Raticate
