Question

Nidhi is maintaining the marksheet of her class in MS Excel. She is asked by her
class teacher to list all students whose marks of Maths subject is greater than or
equal to 80 and less than 90. Suggest her the method that will help her to finish
the task.​

Answer 1

Answer:

Step 1: Click the Home tab on the Ribbon and then click the Conditional Formatting from the Styles group

Step 2: Select the required option from the drop down list to specify the condition. For example, Highlight Cells Rules → Greater Than. A dialogue box appears

Step 3: Type the value and choose formatting style.

Step 4: Click OK button.