Excel 2016 Tips and Tricks

Excel 2016

Lesson – Using Conditional and Custom Formats

Editing a conditional format

NOTE To edit the formatting of the rule, select the Format button in the Edit Formatting Rule dialog box, and then specify the desired formatting in the Format Cells dialog box. Excel does not check to make sure that your conditions are logically consistent, so you need to be sure that you enter your conditions correctly.



P ROCEDURES

1. Drag to select the range of cells that you wish to edit. 2. Release the mouse button.

3. Select the

button in the Styles group on the Home tab.

4. Select the Manage Rules option. 5. Select the rule you want to change.

6. Select the button. 7. If you wish to change the condition, select the condition list . 8. Select the new condition. 9. If you wish to change the criterion, select the current criterion.

OFFICEPRO, Inc.

Page 5