Sending 2007 files to 2003 users--conditional formatting

B

Bliss

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?
 
B

Barb Reinhardt

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.
 
H

Harald Staff

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

Best wishes Harald
 
Top