Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google spreadsheet: Remove conditional formatting, but keep the format

Is there a way to remove the conditional formatting from cells, while keeping the applied format intact?

like image 361
Sebastian Hofer Avatar asked Feb 11 '16 15:02

Sebastian Hofer


2 Answers

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).
like image 81
Tom Kluyskens Avatar answered Oct 31 '22 08:10

Tom Kluyskens


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.
like image 24
TomWalker Avatar answered Oct 31 '22 08:10

TomWalker