Final answer:
To customize conditional formatting in a spreadsheet, select 'New Rule' from the conditional formatting menu, where you can set custom conditions and formatting styles. 'Manage Rules' lets you edit existing rules, while 'Clear Rules' removes the formatting. In document editing, use 'Previous' and 'Next' to navigate through changes.
Step-by-step explanation:
To customize the condition and format using conditional formatting in spreadsheet programs such as Microsoft Excel, you should select 'New Rule' from the drop-down menu of the conditional formatting command. This option allows you to create a specific rule that is not available in the default list. You can set up the conditions based on which your data will be formatted, such as cells that contain specific text, are above or below a certain number, have duplicate values, and so on. After setting the condition, you can also specify the formatting style like font color, cell color, or borders.
Once you have set up a new rule, if you want to review or edit it, you need to go to the 'Manage Rules' option in the conditional formatting drop-down menu. This section lists all the rules currently applied to the spreadsheet and allows you to edit, delete, or change the order in which the rules are applied.
Should you wish to remove conditional formatting, the 'Clear Rules' option is available. This can be used to clear the formatting from selected cells or the entire spreadsheet.
To navigate consecutively through changes, specifically in document editing platforms such as Microsoft Word, you can click the Previous and Next buttons that are located beside the Accept and Reject options within the tools ribbon. This is useful when reviewing revisions in a document.