The ASAP Utilities menu in Excel (English)
Freeze Conditional Formatting as Static Formatting in Selected Cells
ASAP Utilities › Range › 14. Freeze Conditional Formatting as Static Formatting in Selected CellsThis tool replaces conditional formatting in your selected cells with regular static formatting. It preserves the appearance created by conditional formatting rules (such as font color, fill color, borders, and number format) and applies that formatting directly to the cells. The underlying rules are then removed, but the visual result stays the same. This is useful when:
This tool does the same thing for conditional formatting: it keeps the visual formatting and removes the underlying rules that applied it. Note:
Conditional Data Bars and Icon Sets are not supported. These will not be converted to static formatting, and the cells with such rules will remain unchanged.
Screenshots
Starting this tool
- Click ASAP Utilities › Range › 14. Freeze Conditional Formatting as Static Formatting in Selected Cells
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for this tool:
freeze conditional formatting, make conditional formatting permanent, convert conditional formatting to static, remove conditional formatting keep formatting, replace conditional formatting with fixed formatting, convert conditional formatting to standard formatting, flatten conditional formatting, static formatting Excel, lock cell formatting, stop conditional formatting updates, simplify conditional formatting, remove dynamic formatting Excel, keep formatting remove rules, convert rules to regular formatting
freeze conditional formatting, make conditional formatting permanent, convert conditional formatting to static, remove conditional formatting keep formatting, replace conditional formatting with fixed formatting, convert conditional formatting to standard formatting, flatten conditional formatting, static formatting Excel, lock cell formatting, stop conditional formatting updates, simplify conditional formatting, remove dynamic formatting Excel, keep formatting remove rules, convert rules to regular formatting
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Replace Values with Their Formatted Value |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.