FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The New Formatting Rule dialog allows end-users to create new conditional formatting rules and customize the appearance of cells that meet the given criteria. This dialog can be invoked by clicking the New Rule… item in the Conditional Formatting drop-down menu.

Detailed explanation-2: -Click the Conditional Formatting button on the Home tab. Select Manage Rules. The Conditional Formatting Rules Manager, where you can edit or delete existing rules, opens.

Detailed explanation-3: -In the Conditional Formatting Rules Manager, you can choose to show formatting rules for the areas of a workbook that have rules, such as the current selection or a specific worksheet. You can then create, edit, and delete rules as well as manage the precedence of rules for the cells or worksheet you selected.

Detailed explanation-4: -New rule types Formula – you can now specify the formatting criteria using a logical formula in Excel for the web. This rule type gives you the added flexibility of formatting a range based on the result of a function or evaluate data in cells outside the selected range.