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?