Number format using Color index is not working in Excel for Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2009750%22%20slang%3D%22en-US%22%3ENumber%20format%20using%20Color%20index%20is%20not%20working%20in%20Excl%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2009750%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20Color%20Index%20on%20number%20format%20in%20Excel%20for%20windows%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%5BColor10%5D%23%2C%23%230.00%3B%5BRed%5D%23%2C%23%230.00%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOpening%20this%20excel%20on%20Mac%20cause%20an%20error%20getting%20a%20message%20trying%20to%20recover%20formatting%20and%20end%20up%20with%20no%20formatting%20at%20all.%20I%20noticed%20that%20this%20is%20only%20the%20case%20when%20I%20use%20Colorindex%20apart%20from%20the%20named%20colors%20i.e.%20blue%2C%20green%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20faced%20similar%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3EManos%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2009750%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2010526%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20format%20using%20Color%20index%20is%20not%20working%20in%20Excel%20for%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2010526%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F909538%22%20target%3D%22_blank%22%3E%40Manos2465%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20due%20to%20the%20different%20color%20management%20in%20the%20operating%20systems.%3C%2FP%3E%3CP%3EIt%20is%20best%20to%20use%20the%20color%20name%20instead%20of%20the%20indexing.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone,

 

I use Color Index on number format in Excel for windows:

 

[Color10]#,##0.00;[Red]#,##0.00

 

Opening this excel on Mac cause an error getting a message trying to recover formatting and end up with no formatting at all. I noticed that this is only the case when I use Colorindex apart from the named colors i.e. blue, green etc.

 

Have you faced similar issue?

 

Kind regards,

Manos

2 Replies

Hi @Manos2465 

 

That is due to the different color management in the operating systems.

It is best to use the color name instead of the indexing.

@Jihad Al-Jarady Thank you Jihad, still this is not convenient at all. as you don't have the availability of all colors.

 

Moreover and most annoying is that windows users are not aware of this limitation and on top Mac users are not prompted that its something not supported by their system... but rather a message for file repaid attempt...