Turn a conditional formatting into a normal

Range > Convert conditional format to direct

This Excel utility allows you to transform conditional formatting into normal cell formatting. It copies the visible styles used by conditional formatting and stores them in the usual format of cells so that they do not depend on the specified conditions. This is useful for saving table styles or creating static formats for transmission to other users.

Screen shot

After application:

Starting this tool

Click YLC Utilities > Range > Convert conditional format to direct :

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, actual time savings depends on how often you use Excel , the amount of data you work with and how often you use this tool.

Download extensions

You can use the utility Convert conditional format to direct by installing the extension YLC Utilities .

This feature will be available in all files that will be opened in Excel.