Replace conditional formatting with static formatting in selection

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Format › 20. Replace conditional formatting with static formatting in selection

This tool replaces the conditional formatting in the selected cells with regular (static) formatting.
The formatting, that has been applied via conditional formatting rules (number, font, border and fill) is verified and then applied as regular (static) formatting.
The conditional formatting rules are then removed, but not the effects.

A practical example:
'We work a lot with conditional formatting, but our client wants us to "freeze" the format (which means no more use of conditional formatting...) in order to have a classical Excel format (mainly cell and font colors). The idea is to do the same thing as we can do with formulas or calculations "copy > paste as values" but for conditional formatting.'

Note:
Data Bars and Icon Sets cannot be made static with this tool.

Screenshots

Format › 20 Replace conditional formatting with static formatting in selection

Starting this tool

Click ASAP Utilities › Format › 20. Replace conditional formatting with static formatting in selection
Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...

Additional keywords for this tool:
make conditional formatting permanent, convert conditional formatting into standard one

Remove all conditional formatting in selection

Count and/or color duplicates in selection...

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

Empowering Excel Users Worldwide for 26 Years