Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Sending 2007 files to 2003 users--conditional formatting

I have created worksheets that have a lot of conditional formatting. When I
send the file to Excel 2003 users, most of the conditional formatting is
gone/not visible (such as the new features--icon sets, shaded bars, etc.).
Is there a workaround besides having the receiver upgrade to 2007?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,355
Default Sending 2007 files to 2003 users--conditional formatting

I'm only guessing here because I don't have 2007 yet. 2003 only allowsed
for 3 conditional formats to be set without using VBA. 2007 appears to allow
far more than that. I'm guessing that anything over the first three aren't
being displayed for the users on 2003.
--
HTH,
Barb Reinhardt



"Bliss" wrote:

I have created worksheets that have a lot of conditional formatting. When I
send the file to Excel 2003 users, most of the conditional formatting is
gone/not visible (such as the new features--icon sets, shaded bars, etc.).
Is there a workaround besides having the receiver upgrade to 2007?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 449
Default Sending 2007 files to 2003 users--conditional formatting

No, most of the features you describe were written for Excel 2007. She'll
need to upgrade.

Best wishes Harald

"Bliss" wrote in message
...
I have created worksheets that have a lot of conditional formatting. When
I
send the file to Excel 2003 users, most of the conditional formatting is
gone/not visible (such as the new features--icon sets, shaded bars, etc.).
Is there a workaround besides having the receiver upgrade to 2007?


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 batch convert 97-2003 .xls files to 2007 .xlsx files Dave Nuttall Excel Discussion (Misc queries) 4 August 3rd 09 11:38 PM
Formatting and allow users to edit ranges (excel 2003) mich879 Excel Discussion (Misc queries) 0 May 23rd 08 02:30 PM
Saving Excel 2007 conditional formatting in Excel 2003 format [email protected] Excel Discussion (Misc queries) 0 March 28th 08 06:42 AM
Conditional Formatting: Excel 2003 vs. 2007 JP Excel Worksheet Functions 3 January 13th 07 11:33 PM
converter tool to convert XL 2007 files to XL 2003 files Dave F Excel Discussion (Misc queries) 6 December 15th 06 12:45 AM


All times are GMT +1. The time now is 02:03 PM.

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

About Us

"It's about Microsoft Excel"