[go: up one dir, main page]
Scribd
Upload
13 views3 pages

Conditional Formatting

The document provides examples of conditional formatting exercises for ABC Company and Grand University, focusing on expense management and student enrollment percentages. It includes instructions for formatting expenses over a certain threshold and highlights the highest and lowest student performance. The data is presented in tabular form for clarity.

Uploaded by

arangocomandante
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
13 views3 pages

Conditional Formatting

The document provides examples of conditional formatting exercises for ABC Company and Grand University, focusing on expense management and student enrollment percentages. It includes instructions for formatting expenses over a certain threshold and highlights the highest and lowest student performance. The data is presented in tabular form for clarity.

Uploaded by

arangocomandante
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Conditional Formatting

Conditional Formatting

Example 1 - ABC Company

1996 1997
Advertising $ 1,200.00 $ 1,000.00
Commissions $ 24,650.00 $ 24,790.50
Rent $ 500.00 $ 500.00
Utilities $ 75.00 $ 75.00
Insurance $ 1,001.00 $ 100.00
Telephone $ 127.50 $ 145.00
Office Supplies $ 102.95 $ 98.00
Interest $ 859.75 $ 852.00
Marketing $ 11,000.00

Page 1
Ex Cond F

Conditional Formatting Exercise

Exercise 1 - ABC Company

1997 Expenses
Advertising $ 1,000.00
Commissions 24,790.50 Instructions
Rent 500.00 Set conditional formatting so that a
Utilities 75.00 1997 Expense amount that is over
Insurance 100.00 900 is formatted Red.
Telephone 145.00
Office Supplies 98.00
Interest 852.00
Total Expenses $ 27,560.50

Page 2
Conditional Formatting Using Functions

Exercise 1 - Grand University Student Enrollment

ABOVE
AVERAGE

Final Percentage
LastName FirstName BUS 100 MGMT 121 ECON 150
Moore Andrew 87% 81% 89%
Zhou Katie 47% 53% 36%
Richard Megan 76% 84% 63%
Holcombe James 60% 52% 46%
Lee Taylor 90% 93% 84%
Herbert Steven 62% 64% 60%
Whiting Ross 71% 78% 75%
Bhatti Prakash 60% 75% 56%
Weller Chloe 83% 73% 63%
Sigismund Amy 79% 72% 85%
Bennett Ryan 66% 64% 57%
Astor Cameron 89% 91% 90%
Theodoric Jack 64% 69% 62%
Howard Jack 48% 40% 30%

Exercise 2 - Grand University Student Enrollment

HIGHEST LOWEST

Final Percentage
LastName FirstName BUS 100 MGMT 121 ECON 150
Moore Andrew 87% 81% 89%
Zhou Katie 47% 53% 36%
Richard Megan 76% 84% 63%
Holcombe James 60% 52% 46%
Lee Taylor 90% 93% 84%
Herbert Steven 62% 64% 60%
Whiting Ross 71% 78% 75%
Bhatti Prakash 60% 75% 56%
Weller Chloe 83% 73% 63%
Sigismund Amy 79% 72% 85%
Bennett Ryan 66% 64% 57%
Astor Cameron 99% 91% 90%
Theodoric Jack 64% 69% 62%
Howard Jack 30% 40% 30%

You might also like