What colors can be used in formulas

I think this ought to be a simple question, but it isn’t. I’ve done dozens of web searches, and searched the forum, and can’t find the answer.

I want to highlight numbers in certain columns based on positive or negative. That much is simple:


in “Format Cells” makes positive numbers blue and negative numbers red. But the blue doesn’t stand out as much as I need.

This also works:


but the green is too light and is difficult to read. So I tried this:


This does not work, even though the color table that shows up when I click on the Font Color icon includes Violet.

I can’t find a list anywhere that says what colors will work in this type of cell format. This ought to be somewhere in the documentation, but for reasons I can’t even guess it appears to be deeply hidden. I can’t find it anywhere in the documentation, nor in this forum.

There are many entries that talk about using embedded code to define colors, or how to change background colors, or other color-related topics: but nothing I can find gives the list of pre-defined colors that will work to format numbers in a cell.

Could someone please tell me what the list is, or where to find it, or how to get other colors to work?

I played around a bit. It looks like only the basic colors are supported: RED, GREEN, BLUE, YELLOW, CYAN and MAGENTA.

To find the “deeply hidden” topic, one could go one of these ways: from Calc’s Format Cell dialog, click Help → in the opened Numbers/Format help page, click Number format codes in Related Topics in the bottom of the page. Or from StarBasic help, one could find Format function help, and then again, open the link in Related Topics.

The supproted names are listed in the Number Format Codes topic in LibreOffice help.

OK, this a year old response but I’ve was trying to also find an alternative green to [GREEN] when plugged into fromat code field.

It seems there is half support for more than the basics listed at libre office help docs under format code - color

Seems there are some collors you can use from 00 to 20+ maybe. For example [COLOR23] gives me a nice readable green.

*** OK UPDATE, [COLOR##] ## being 00 up to 20+… works only for the session. If I save/close then reopen the calc file, the userdefined format code is not saved. If I plug it and save, it desplays fine until I close the file.

In fact, 1 to 64.

Thanks for the pointers. I don’t know why none of this showed up in my web searches. I did suspect that only the primary colors would work, but could not find it documented anywhere.

Do you think it would be asking too much to request that additional colors be supported? How does one go about making such a request?

(Your “answer” should be a comment to the real answer.)
I also would like to see more color options. I think there’s no open bug yet. I found a meta-bug titled ”Number format bugs and enhancements“. Take a look at its dependency tree.

I am using LibreOffice and I can use these colors:
red, green, blue, cyan, magenta, yellow, black, white,
silver, lime, aqua (cyan), olive, gray, purple, maroon, teal, navy, fuchsia (magenta)
color maroon {
%sigma_{1,1} = [ 0,1,2 ]

OP’s tagging is confusing because (s)he mentioned all components except Writer and the question is about Calc.
Your answer and example are valid for Math where the set of available colours is different.

Yes, You have right.
I wanted to post answer here: Coloured equation in Impress
but it looks locked. My answer here was probably inserted to fast, as I did not read question…
Should I remove it?

Considering the confusing tags, leave it here. It brings anyway good information and my comment disambiguates it.