Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 577
  • Last Modified:

Condifiotnal formatting. Color differences Windows-Mac

Hi,

I have Excel spreadsheet with conditional formatting.
The document has been prepared in Windows and when viewing it in Excel for Mac the colors (applied by conditional formatting) differs from the Windows version.
For example green turns red, etc..

As the document contains financial information the changes in colors are most unwelcome.

Any ideas what's happening?

Thanks
0
pkarda
Asked:
pkarda
  • 2
  • 2
1 Solution
 
andreyman3d2kCommented:
What versions of Excel are you using? (On both PC and Mac)
0
 
pkardaAuthor Commented:
2007 on Windows, and 2008 on Mac

0
 
andreyman3d2kCommented:
An issue can be that you used more than 3 colors/cell for the conditional formatting when you made the spreadsheet (assuming you used Excel 2007), while Mac Excel supports on 3 colors. Not sure what it does in this case, but that might account for the mis-coloring. Also, if you used the Excel 2007 Theme colors, those also might not be supported. Try sticking to the basic colors (40 of them) that are supported by Excel 2003.
0
 
pkardaAuthor Commented:
great, cheers
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now