A teacher takes the following steps when beginning to apply conditional formatting to a spreadsheet. Format Conditional Formatting Add 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.

Question

Computers and Technology

Gage Gould

2 November, 05:53

A teacher takes the following steps when beginning to apply conditional formatting to a spreadsheet. Format Conditional Formatting Add 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.

+5

Answers (1)

Know the Answer?

Zachary Young · Answer 1

To do conditional formatting for range of values Between is the right keyword where the starting range and the ending range can be defined. According to the question, the starting range is 90 and the ending range is 100.

So, between under the equal menu in the excel needs to be selected and the first field should contain the number 90 and the second field should hold 100. In the result, it includes field with 90 and 100 too. All the other option does not suit the objective.