Question: I need a way to remove all conditional formatting by running a script (my client will be using this and he doesn't want to have to repeat the process of removing conditional formatting for each worksheet in each of a large number of spreadsheet files).

Is there any way to do this via Google Apps script? All I see is `.clearFormat()`, which unfortunately clears all formatting, of which a lot should not be deleted (eg, font color, bg color, font, font weight, font rotation, cell outlines)

How to do this in such a way that only one button needs to be pressed for each spreadsheet file?

Answer: 
Google Apps Scripts now supports removing conditional formatting using `clearConditionalFormatRules`

```
var sheet = SpreadsheetApp.getActiveSheet();
sheet.clearConditionalFormatRules();

```

<https://developers.google.com/apps-script/reference/spreadsheet/sheet#clearconditionalformatrules>
1. Copy a cell that doesn't have any conditional formatting.
2. Select the cell(s) you want to remove the conditional formatting from.
3. Edit -> Paste special -> Paste conditional formatting only.