Your conditional formatting rules are scattered across tabs — and impossible to see.

Google Sheets shows conditional formatting one tab at a time, in a narrow panel, with no overview. Rules pile up as spreadsheets grow: duplicated by copy-paste, shadowed by priority order, and impossible to move to another file. Format Rules Manager turns that hidden layer into something you can see and manage.

Format Rules Manager is a free Google Sheets add-on that lists every conditional formatting rule on every tab in one sidebar — then lets you copy conditional formatting between tabs, move formatting rules to another spreadsheet, find and merge duplicate rules, reorder rule priority, and back up all your rules as JSON.

WHAT YOU CAN DO

- See every rule on every tab: color swatches, plain-language summaries ("Text contains 'Won'", "Custom formula =$C2>1000"), and the ranges as clickable chips that jump straight to the cells.
- Bulk delete and reorder: select rules across tabs and delete them in one step. Reorder priorities with arrows and apply the new order in a single write.
- Copy between tabs: copy rules to any tabs in the spreadsheet with their exact ranges, appended after the target's existing rules — no static-formatting side effects, no accidental duplicates.
- Move rules to another spreadsheet: export rules as JSON, then paste them into Import in the other file. The preview maps rules to tabs and validates everything before a single rule is written.
- Clean up duplicates: identical rules are flagged automatically. Merge a duplicate group into one rule covering all its ranges — only when it is provably safe to do so. Rules that do nothing are flagged too.
- Back up and restore: export a rule, a tab, or the whole workbook as structured JSON and restore it later — into the same file or a copy.
- Undo every change: every operation takes a snapshot first. Undo restores the affected tabs exactly — even after closing and reopening the sidebar.

PRIVATE BY DESIGN

- Only two permissions: access to the spreadsheet the add-on is running in (spreadsheets.currentonly) and permission to show its sidebar. No Google Drive access, no access to your other files.
- Spreadsheet content is not sent to external CloudNetix servers. Processing happens inside Google's infrastructure, and undo snapshots are stored in the spreadsheet's own document properties, inside your Google account.
- No CloudNetix account, no sign-up, no background triggers. The add-on runs only when you open it and acts only when you click.

100% FREE. No subscription, no paid tier.

Format Rules Manager manages exactly what Google Sheets conditional formatting supports (bold, italic, strikethrough, underline, text color, background color, and color scales) — without workarounds that could corrupt your rules. Very large workbooks load tab-by-tab, and every limit is announced in the interface; nothing is silently truncated.

Questions or feedback? support@cloudnetix.de
Learn more and read the guides: https://format-rules-manager.cloudnetix.de

Google Sheets and Google Workspace are trademarks of Google LLC. Format Rules Manager is an independent add-on developed by CloudNetix and is not affiliated with or endorsed by Google LLC.