Ask Your Question
0

What colors can be used in formulas

asked 2018-09-04 13:00:27 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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:

[BLUE]0;[RED]-0

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:

[GREEN]0;[RED]-0

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

[VIOLET]0;[RED]-0

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?

edit retag flag offensive close merge delete

Comments

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

ebot gravatar imageebot ( 2018-09-04 13:35:52 +0200 )edit

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.

Mike Kaganski gravatar imageMike Kaganski ( 2018-09-04 15:46:48 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2018-09-04 15:40:06 +0200

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

edit flag offensive delete link more
0

answered 2018-09-05 13:07:10 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-04 13:00:27 +0200

Seen: 112 times

Last updated: Sep 05 '18