NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Formatting›Remove conditional formatting

Google Sheets · Verified tutorial

Remove conditional formatting in Google Sheets

Remove the conditional-formatting rule from A2:B5. Keep all values and ordinary cell formatting unchanged.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Remove the conditional-formatting rule from A2:B5. Keep all values and ordinary cell formatting unchanged.

Step-by-step

1

Select the targetRemove the conditional-formatting rule from A2:B5.

2

Apply the changeKeep all values and ordinary cell formatting unchanged.

Shortcut or faster method

Select the full target range first. This avoids repeating the same change cell by cell.

Expected result

No conditional-formatting rule applies to A2:B5.

Common mistake

Starting with the wrong cell or range selected.

Troubleshooting

Re-select A2:B5 and repeat the final action. No conditional-formatting rule applies to A2:B5.

Example spreadsheet data

This is the clean fixture used for the verified run.

Item	Stock
Notebook	12
Pen	4
Folder	7
Tape	2

Video transcript

Open the prepared Practice spreadsheet.
Select the target. Remove the conditional-formatting rule from A2:B5.
Apply the change. Keep all values and ordinary cell formatting unchanged.
No conditional-formatting rule applies to A2:B5.