logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

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

Format » 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:
This tool works in all Excel versions except for Excel 2007.
Data Bars and Icon Sets cannot be made static with this tool.

Screenshots

Format » Replace conditional formatting with static formatting in selection

Starting this utility

In the Excel menu choose: ASAP Utilities » Format » Replace conditional formatting with static formatting in selection

« Return to the list of “Format” tools.
« Previous
Remove all conditional formatting in selection
 
 Next »
Count and/or color duplicates in selection...
Excel 2010 with ASAP Utilities in the menu
Download ASAP Utilities
Additional keywords for this tool:
make conditional formatting permanent, convert conditional formatting into standard one

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook