Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I convert conditional formatting into explicit formatting? Patrick Harris Excel Discussion (Misc queries) 0 April 9th 09 12:00 AM
Conditional Formatting does not convert HTML Al Prior Excel Discussion (Misc queries) 0 April 14th 08 02:01 AM
Convert Conditional Formatting Into VBA Code Button Dean P. Excel Programming 0 December 17th 07 10:38 PM
Protect Cell Formatting including Conditional Formatting Mick Jennings Excel Discussion (Misc queries) 5 November 13th 07 05:32 PM
conditional Formatting based on cell formatting Totom Excel Worksheet Functions 3 January 20th 07 02:02 PM


All times are GMT +1. The time now is 03:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"