Question

:) What is the advantages of conditional formatting? How will you change a conditional formatting rale?​

Answer 1

So what are the advantages of conditional formatting? The spreadsheet will have the ability to format itself as you are working on it in real time. This means that anything you do within the spreadsheet will be brought to your attention quicker if the cells were to change their format.

To create a conditional formatting rule:

Select the desired cells for the conditional formatting rule.

From the Home tab, click the Conditional Formatting command. ...

Hover the mouse over the desired conditional formatting type, then select the desired rule from the menu that appears. ...

A dialog box will appear.

follow me!!!