How can I change custom number formatting colors using Hex?

user_12997159 0
Viewed 838

I want to change the colours for custom number formatting - "% change".
This is an example of a spreadsheet using standard colours.

SpreadsheetView

This is the standard Custom Number format screen:

enter image description here

I was wondering if there is a way to change to intensity of [green] and [red] colours and Google Sheet to make the arrows appear less striking to the eyes..

came across this thread while searching for ideas - Google sheets custom number format, color specification

Below is my formatting formula - is there a way for me to change the intensity of the formatted colors?

enter image description here

google-sheets
1 Answers

Answer:

From the Format > Number > More Formats > Custom number format menu item, you can specify the colours you wish to use for your number formats as one of a specific set of 56 colours.

Example:

For example, you can use the following code:

[Color10]⮝ 0%;[Color30]⮟ 0%

To change the tone of the green and red colours. This is the green and this is the red.

Here's an example of how it looks:

enter image description here

References:

user_115514680
Related