Question

What is the advantage of using conditional formatting in excel?

Answer 1

Answer:

the advantage of using conditional formatting in excel are-

Explanation:

Answer 2

Conditional Formatting is a feature that applies automatic formatting to data that meets a certain criteria.

• Conditional Formatting is a unique feature in spreadsheet applications like MS Excel and google sheets. By using this feature users can apply automatic formatting to data in the sheet, based on some specified conditions.

• For example- we can apply a condition to automatically change the font color to red in case entered numbers have a negative value.

• To apply conditional formatting select the cells where this feature has to be applied --> go to home tab--> styles group --> click on 'conditional formatting option' --> this shall invoke a drop down-->Select 'new rule' option--> this shall further invoke the 'new formatting rule' window --> Under 'select a rule type', specify the type of rule you need--> Under the 'Edit the rule description' select the format style--> Finally, click OK to apply the conditional formatting rule to the selected cells on the sheet.

To know more about, conditional formatting, visit:

https://brainly.in/question/12838522