Question

8. What are the steps in conditional formatting?​

Answer 1

Answer:

• Select the range A1:A10.
• On the Home tab, in the Styles group, click Conditional Formatting.
• Click Highlight Cells Rules, Greater Than.
• Enter the value 80 and select a formatting style.
• Click OK. Result. Excel highlights the cells that are greater than 80.
• Change the value of cell A1 to 81.

Answer 2

Answer:

Conditional Formatting

1. Select the range A1:A10.

2. On the Home tab, in the Styles group, click Conditional Formatting.

3. Click Highlight Cells Rules, Greater Than.

4. Enter the value 80 and select a formatting style.

5. Click OK. Result. Excel highlights the cells that are greater than 80.

6.Change the value of cell A1 to 81.