Manage Rules allows you to view, edit, delete, and add rules. To manage conditional formatting rules:  This will open the Conditional Formatting Rules Manager dialogue box:  Select the formatting rules for dropdown to view rules for the current selection or any other worksheet  or table within the workbook. You may add, edit or delete a rule from the Conditional Formatting Rules  Manager. 26  Manage Rules  2. Select  Manage Rules .  1. Select  Conditional Formatting .