ConditionalFormatting Assignment (1) (1).xlsx

	B	C	D	E	F	G	H	I
1	Conditional Formatting and Smart Art Assignment
2
3
4	From Wikipedia, the free encyclopedia
5	The table below lists the 100 largest census subdivisions (municipalities or municipal equivalents) in Canada by population, using data from the 2021 census for census subdivisions.[1]
6	This list includes only the population within a census subdivision's boundaries as defined at the time of the census. Many census subdivisions are part of a larger census metropolitan area or census agglomeration. For their ranking, see the list of census metropolitan areas and agglomerations in Canada.
7
8
9	Rank (2021)	Municipality	Province	Population (2021)	Population (2016)	% Change	Land area (km2)	Population density (/km2)
10	1	Toronto	Ontario	2,794,356	2,731,571		631.1
11	2	Montreal	Quebec	1,762,949	1,704,694		364.74
12	3	Calgary	Alberta	1,306,784	1,239,220		820.62
13	4	Ottawa	Ontario	1,017,449	934,243		2788.2
14	5	Edmonton	Alberta	1,010,899	933,088		765.61
15	6	Winnipeg	Manitoba	749,607	705,244		461.78
16	7	Mississauga	Ontario	717,961	721,599		292.74
17	8	Vancouver	British Columbia	662,248	631,486		115.18
18	9	Brampton	Ontario	656,480	593,638		265.89
19	10	Hamilton	Ontario	569,353	536,917		1118.31
20	11	Surrey	British Columbia	568,322	517,887		316.11
21	12	Quebec City	Quebec	549,459	531,902		452.3
22	13	Halifax	Nova Scotia	439,819	403,131		5475.57
23	14	Laval	Quebec	438,366	422,993		246.13
24	15	London	Ontario	422,324	383,822		420.5
25	16	Markham	Ontario	338,503	328,966		210.93
26	17	Vaughan	Ontario	323,103	306,233		272.44
27	18	Gatineau	Quebec	291,041	276,245		341.84
28	19	Saskatoon	Saskatchewan	266,141	247,201		226.56
29	20	Kitchener	Ontario	256,885	233,222		136.81
30	21	Longueuil	Quebec	254,483	239,897		115.77
31	22	Burnaby	British Columbia	249,125	232,755		90.57
32	23	Windsor	Ontario	229,660	217,188		146.02
33	24	Regina	Saskatchewan	226,404	215,106		178.81
34	25	Oakville	Ontario	213,759	193,832		138.94
35	26	Richmond	British Columbia	209,937	198,309		128.87
36	27	Richmond Hill	Ontario	202,022	195,022		100.79
37	28	Burlington	Ontario	186,948	183,314		186.12
38	29	Oshawa	Ontario	175,383	159,458		145.72
39	30	Sherbrooke	Quebec	172,950	161,531		353.4
40	31	Greater Sudbury	Ontario	166,004	161,531		3186.26
41	32	Abbotsford	British Columbia	153,524	141,397		375.33
42	33	Lévis	Quebec	149,683	143,414		448.07
43	34	Coquitlam	British Columbia	148,625	139,284		122.15
44	35	Barrie	Ontario	147,829	141,434		99.01
45	36	Saguenay	Quebec	144,723	145,949		1124.63
46	37	Kelowna	British Columbia	144,576	127,390		211.85
47	38	Guelph	Ontario	143,740	131,794		87.43
48	39	Trois-Rivières	Quebec	139,163	134,413		288.65
49	40	Whitby	Ontario	138,501	128,377		146.69
50	41	Cambridge	Ontario	138,479	129,920		112.99
51	42	St. Catharines	Ontario	136,803	133,113		96.2
52	43	Milton	Ontario	132,979	110,128		363.83
53	44	Langley	British Columbia	132,603	117,285		307.22
54	45	Kingston	Ontario	132,485	123,798		451.58
55	46	Ajax	Ontario	126,666	119,677		66.64
56	47	Waterloo	Ontario	121,436	104,986		64.06
57	48	Terrebonne	Quebec	119,944	111,575		153.76
58	49	Saanich	British Columbia	117,735	114,148		103.59
59	50	St. John's	Newfoundland and Labrador	110,525	108,860		446.02
60	51	Thunder Bay	Ontario	108,843	107,909		327.77
61	52	Delta	British Columbia	108,455	102,238		179.66
62	53	Brantford	Ontario	104,688	98,563		98.65
63	54	Chatham-Kent	Ontario	103,988	101,647		2451.9
64	55	Clarington	Ontario	101,427	92,013		610.84
65	56	Red Deer	Alberta	100,844	100,418		104.34
66	57	Nanaimo	British Columbia	99,863	90,504		90.45
67	58	Strathcona County	Alberta	99,225	98,024		1170.65
68	59	Pickering	Ontario	99,186	91,771		231.1
69	60	Lethbridge	Alberta	98,406	92,729		121.12
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100