Question

What is the use of conditional formatting?​

Answer 1

Answer:

Conditional Formatting

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.

Explanation:

mark as brainliest