Is there a way to remove the conditional formatting from cells, while keeping the applied format intact?
The only way I've found is:
- Copy the cells.
- Clear formatting on the cells (
ctrl + \
)
- Paste special -> Paste format only (paste over the said cells).
Yes, to remove individual conditional formats while leaving other formatting unchanged, in Google Sheets:
- If the conditional format pane on the far right is present, close it by clicking the X in the top right of the pane.
- Highlight the range of cells (or select a single cell if you want to remove conditional format for only 1 cell) that have conditional formatting applied. For this to work, at least one of the cells you've highlighted must have conditional formatting defined.
- Right click the highlighted cells and select "Conditional Formatting" from the context menu.
- A vertical panel on the right will appear with a list of conditional format rules that are present in the highlighted range.
- Hover the cursor (do not click -- just hover) over the rule you want to delete. As you hover a trash can icon will appear.
- Click the trash can icon to remove that particular conditional format.