Answer:
The answer to this question is given below in the explanation section.
Explanation:
In excel you can formate excel sheet/column/row based on some condition.
you can specifiy these conditions while working on an excel sheet. It will help you to highlight certain information in the excel sheet.
Basically, you can use the rules to specify certain conditions, and based on that condition result, the cell/column or row gets highlighted with a certain color format, etc. However, you can create a new rule and modify the existing rules also.
As in the given question, you can implement this by going through the following steps.
On the <u>Home </u>tab, click the <u>Conditional Formatting </u>group. On the Styles drop-down list, click <u>Manage Rules</u>. In the dialog box, select the rule, and click <u>Edit</u>. Make the changes to the rule and click ok.