Print PDF
Favorite
Email
Step 3Formatting the Rest of the Cells
The rest of the cells will be formatted much like the 1x1 cell, but we will need 3 conditions to satisfy the answer.
Next we will format the 1x2 and 2x1 cells.
Condition 1: Cell value is equal to 1, cell turns red
Condition 2: Cell value equal to 2, cell turns green
Condition 3: Cell value is greater than 2; cell turns red
To show the formatting of the rest of the table, I'll use the 1x3 and 3x1 cells
Condition 1: Cell value is between 1 and 2, cell turns red
Condition 2: Cell value is equal to 3, cell turns green
Condition 3: Cell value is greater than 3, cell turns red
The cells for answer 1 and 2 were the only ones that can be formatted the way they are, the rest follow the formatting of answer 3.
Next we will format the 1x2 and 2x1 cells.
Condition 1: Cell value is equal to 1, cell turns red
Condition 2: Cell value equal to 2, cell turns green
Condition 3: Cell value is greater than 2; cell turns red
To show the formatting of the rest of the table, I'll use the 1x3 and 3x1 cells
Condition 1: Cell value is between 1 and 2, cell turns red
Condition 2: Cell value is equal to 3, cell turns green
Condition 3: Cell value is greater than 3, cell turns red
The cells for answer 1 and 2 were the only ones that can be formatted the way they are, the rest follow the formatting of answer 3.
| « Previous Step | Download PDFView All Steps | Next Step » |
 |
Add Comment
|
