Excel 2008 colored cells not right from Excel 2007 WIN

[boonerite]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi all,
I have been working on an excel sheet which is reasonably large (in terms of cells and rows), and have formatted the colors and fonts and formulas in WINDOWS Office EXCEL 2007

Upon migrating to OS X's Mac Office 2008, opening in the same Excel file causes all the previous colors to be messed up. It is too painful to go through and re-color them in Mac Excel.

Is there a "cheap" way to "save color palette" into the Excel file so that 2008 Excel can read/use it?

Thanks for your time

 

[Excel 2008 user]

I believe this may be one of the incompatibilities between 2007 and 2008.

Conditional color formatting and filter or sort by color don't appear in
2008 or are a subset.

What I suggest as a workaround is to filter by color, then in an added
field, place a code you define to represent the color. Then when you get the
data to 2008, filter on this new field, and re-establish colors that 2008
likes.

Yes, I know it's ugly.

 

[aullrich]

What about the colors just being wrong. Forget conditional formatting...forget sorting by color, it just is grossly wrong. I.e. Blue becomes brown/maroon and light green becomes neon green. Ugh!