NOTE: Using the Copy and Paste Special Formats command to copy a cell containing conditional formatting, also causes all formatting including borders, shading, and fonts to be pasted. This results in more formatting applied than you may expect.
To remove formatting from cells that do not need conditional formats, follow these steps:
- Select the cells from which you need to remove the conditional formatting.
- On the Format menu, click Conditional Formatting.
- In the Conditional Formatting dialog box, click Delete. If you have multiple conditions, click to select the check box for each condition you want to delete. Click OK.
The Preview of format to use when condition is true box should now show "No Format Set." Click OK.
Finding Cells Having Conditional FormatsIf you do not know which cells within your PivotTable may have conditional formats applied to them, follow these steps to select all cells having conditional formatting:
- On the Edit menu, click Go To. In the Go To dialog box, click Special.
- In the Go To Special dialog box, click Conditional formats. Click OK.
The Preserve Formatting option for PivotTable reports retains any formatting you apply to PivotTable report data when you refresh the data or change the report's layout. However, this option does not apply to conditional formatting. If you apply conditional formatting to cells within a PivotTable report, you get unpredictable results if your data changes size or if you pivot fields in the report.
ID d'article : 215986 - Dernière mise à jour : 5 nov. 2003 - Révision : 1