Convert Conditional Formatting to Conventional Formatting
 

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.