[go: up one dir, main page]
Scribd
Upload
12 views2 pages

Activity Sheet Conditional Formating

The document provides instructions for using conditional formatting in Microsoft Excel to highlight important data in two different scenarios: student test scores and weather data. It outlines steps to set up spreadsheets, including creating tables and applying specific formatting rules based on numerical values. The focus is on visually representing data significance through color coding.

Uploaded by

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

Activity Sheet Conditional Formating

The document provides instructions for using conditional formatting in Microsoft Excel to highlight important data in two different scenarios: student test scores and weather data. It outlines steps to set up spreadsheets, including creating tables and applying specific formatting rules based on numerical values. The focus is on visually representing data significance through color coding.

Uploaded by

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

I DO, YOU Do

Activity Sheet: Conditional Formatting in Spreadsheets

Instructions
Follow the steps below to format your data using conditional formatting. You
will use these tools to highlight values based on their importance, such as
test scores, expenses, or personal interests.
Step 1: Set up the Spreadsheet
1. Open a spreadsheet using Microsoft Excel
2. Create a table with the following data:

Student Test Test Test Avera


Name 1 2 3 ge
John 75 80 90 81.67
Sarah 95 85 88 89.33
Matt 60 78 70 69.33
Lily 89 92 94 91.67
Emily 72 85 78 78.33

Step 2: Apply Conditional Formatting


1. Highlight Test Scores:
o Select the range of cells for all test scores (B2-D6)
o Apply conditional formatting:
 If score is 90 or above, change the cell color to blue.
 If score is below 70, change the cell color to red.

DO IT YOURSELF

Activity Sheet: Conditional Formatting in Spreadsheets

Instructions
Follow the steps below to set up a spreadsheet that tracks weather data for
different cities. You will use Conditional Formatting to highlight
temperature ranges, trends, and weather conditions.
Step 1: Set up the Spreadsheet
1. Open a new spreadsheet in Microsoft Excel.
2. Create a table with the following weather data:
Max Temp Min Temp Precipitation
City Condition
(°F) (°F) (%)
New York 75 60 Sunny 10%
Los
85 65 Cloudy 20%
Angeles
Chicago 62 45 Rainy 80%
Thunderstor
Miami 88 75 90%
m
Seattle 60 50 Rainy 70%
Denver 72 55 Sunny 5%
Step 2: Apply Conditional Formatting
1. Max Temperature:
o Select the column with maximum temperatures (Cell B2-B7).
o Apply a color scale where:
 Temperatures 85°F and above are shaded red.
 Temperatures below 65°F are shaded blue.
 Temperatures between 65°F and 84°F are shaded yellow.

You might also like