Business Info

.
Step # 8

Empty Cell Rule to turn cells white.
Step 8        Step By Step  Google Sheets Empty Cell Rule in Sheets.    
or
Watch the Video Formulas Spreadsheet Video on Youtube.           
Excel Step 8
IsBlank Rule

.

.

Step # 9

Conditionally Formatting
G.P.A. Ranges

B3 - I11.

Step # 9           Google Sheets Conditionally Formatting G.P.A. ranges.

Make the numbers turn colors when they're typed into cell.

Grade Point Averages
Values
Format cells if ...
Ranges
F's = 0 points
is between.
0.0 - 0.9
D's = 1 points
1.0 - 1.9
C's = 2 points
2.0 - 2.9
B's = 3 points
3.0 - 3.9
A's = 4 points
4.0 - 4.9
extra credit
Step by Step Instructions
Click for Google Sheets Step 9
Conditional Formatting		 Excel Step 9
Conditional Formatting

Table of Contents for Part 1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Step 8b Make cells white

Step 8
         Make Cells White

 In Sheets
it is known as the
Empty Cell Rule.		 In Excel
it is known as the
Is Blank Rule.
You need to declare the cells white before you can add the Conditional Formatting Rule for each GPA number.

8a. In SHEETS open the Conditional Formatting side bar and format the cells white.
Select cells B3 - I11 >   Format  >  Conditional Formatting

The cells with numbers change color to green.
You need the color to be white.
Step 8b Make cells white

 

Table of Contents for Part 2