globalpaster.blogg.se - Color codes for custom formatting excel

#COLOR CODES FOR CUSTOM FORMATTING EXCEL FOR MAC#
#COLOR CODES FOR CUSTOM FORMATTING EXCEL WINDOWS#

Then specify positive numbers to be black "#,#0% -#,#0%".

To turn positive numbers black again, go to format axis -> axis options -> number -> format code.

select the chart's y-axis, go to font options in the toolbar, and turned the whole axis Dark Red.

If you want to colorize only negative numbers, say, you can override the font formatting for positives by editing it in the number format code.įor instance: I want to color negative numbers on my chart scale Dark Red (a color that isn't one of the 56 colors Excel precoded). I've looked through many threads like this, but the simplest solution for coloring numbers in CELLS is to use conditional formatting.īut for CHARTS, the easiest way is to use the basic font formatting option - you can specify any hex value there. But this behavior is not a bug since Libreoffice/Openoffice Calc is not 100% Excel compatible and does not want it to be.

#COLOR CODES FOR CUSTOM FORMATTING EXCEL WINDOWS#

For me, Libreoffice in 64-bit Ubuntu has 64 color indices (1-64) available while Libreoffice in 32-bit Windows has only 32 color indices (1-32) available. And they are dependent on the platform (64-bit or 32-bit) also. There they are even different from the interior color indices. This could be called a bug in my opinion and could be reported to Microsoft as such.Īs I noted in comments above, the color indices used in are different in Libreoffice/Openoffice Calc also.

#COLOR CODES FOR CUSTOM FORMATTING EXCEL FOR MAC#

If so, then Excel for Mac uses a default color palette from earlier versions than Excel for Windows uses. So one could check whether the indexed colors, which Excel for Mac uses, are the ones which are shown in documentation for ColorIndex Property. But the macro should run in Excel for Mac also. So Excel for Mac and Excel for Windows are not 100% compatible in this point. Maybe simply not updated since earlier versions?Īs Mays had to realize, Excel for Mac also uses different indexed colors. But if we take a look at the Microsoft documentation of ColorIndex Property, we must see, that even Microsoft shows different indexed colors. Running this macro in Excel for Windows (versions 2007 up to 2016 tested) will show, that the for example is orange color. Cells(i, 2).NumberFormat = sNumberFormat To determine which colors are indexed with which index, one could using the following VBA macro: Sub UDColorNumberFormats()

But using with NN being the color index is also possible for 56 indexed colors. There only the 8 named colors, ,, ,, ,, are documented. To specifying colors in number formats one needs to know the guidelines for customizing a number format. Specifying colors in number formats - for this Microsoft itself documents only the 8 named ones. The only ways I know to achieve different font colors depending on values are: