Print PDF
Favorite
Email
Step 2Conditional Formatting
Next we will start with the conditional formatting of the cells. The conditional formatting option is located under the FORMAT menu in Excel.
The first cell we will format is the 1x1 cell. We want the cell to turn green when the user inputs the number 1 and red when the user inputs anything else. You can use any colors that you want, I just chose those because they are familiar with right and wrong.
The first condition will be cell is equal to 1, it turns green.
Second condition is if cell is greater than 1, it will turn red.
-- Use the drop down menus to change the value of each box.
-- The format button is where you can modify the look of each condition.
The first cell we will format is the 1x1 cell. We want the cell to turn green when the user inputs the number 1 and red when the user inputs anything else. You can use any colors that you want, I just chose those because they are familiar with right and wrong.
The first condition will be cell is equal to 1, it turns green.
Second condition is if cell is greater than 1, it will turn red.
-- Use the drop down menus to change the value of each box.
-- The format button is where you can modify the look of each condition.
| « Previous Step | Download PDFView All Steps | Next Step » |
 |
Add Comment
|
