opkcomm.blogg.se - Free asap utilities for excel 2007

This excel tutorial is probably one of the world's most popular FREE excel addins for MS Excel, find out yourself and save also many hours of time ! It contains over 200 useful and powerfull utilities to fill the gaps in Excel, and automate frequently used tasks. Even so, this may work for your needs if the tradeoff is acceptable.Excel addins free: ASAP Utilities makes MS a piece of cake excel addins free: ASAP Utilities makes MS a piece of cake You should be aware, however, that this process also does the same with your formulas, saving everything as a value, instead. In the process of saving the Excel workbook in HTML format, the program "strips" all the conditional formatting and makes it explicit (absolute). (Press F12, specify an Excel workbook format, and give the workbook a different name.)

Save the workbook as an Excel workbook.

Load into Excel the HTML file you saved in step 2.

(Press F12, specify the HTML format, and give the workbook a different name.)

Load the workbook that contains your conditional formatting.

There is another thing you can try, as well, that involves saving your workbook in a different format.

For a good idea of what is involved, you may want to refer to this page on Chip Pearson's website:

The macros are not trivial, however, as VBA doesn't give you a whole lot of help in dealing with conditional formatting. (It would be especially great if you could do it using a Paste Special option, as Parton notes.) You can, however, use some macros to do the trick.

He would like to be able to 'fix' the formatting in a worksheet in a way similar to how Paste Values can be used to 'fix' the values of cells. Parton wonders if there is a way to convert conditional formatting into absolute formatting.