Convert Conditional Formatting to Conventional Formatting

T

timotero

I need to send an Excel 2007 workbook containing a graded color scale
to someone who has Excel 2003. Hence, I need to find a way to remove
the conditional formatting, but keep the formats intact. I've found
some excellent code, done by Chip Pearson, for Excel 2003 and
previous, but cannot find any which works on Excel 2007.

Any assistance is greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top