A teacher takes the following steps when beginning to apply conditional formatting to a spreadsheet. Format - Conditional Formatting - Add Condition 1 Equal
What should her next step be if she is attempting to highlight cells with values greater than 90 but less than 100?
• Click "between" under the equal menu, and then enter 90 in the first field and 100 in the second field.
Click "greater than" and enter 90. Then apply Condition 2 and click "less than" under the equal menu and enter
100.
• Click "Apply Style", and enter 90 in the first field and 100 in the second field.
• Click Result 1, apply Condition 2, and click Result 2.