Microsoft Office Tutorials and References
In Depth Information
Deleting conditional formats
Deleting conditional formats
If you no longer want to use conditional formats to summarize
the data in your workbook, you can delete the formats without
affecting the underlying data. When you delete a conditional
format, you can select whether to do so for the selected cells,
the entire sheet, the active PivotTable, or the active Excel table.
Delete conditional formats
1 Select the cells with the conditional formatting that you want to
delete.
2 Click the Home tab.
3 In the Styles group on the ribbon, click Conditional Formatting.
4 Point to Clear Rules.
5
2
3
Click the set of rules that you want to delete.
1
5
4
Search JabSto ::




Custom Search