CODEWITHSUNDEEP
google-sheets
adelle
adelle

Reputation: 199

How can I change custom number formatting colors using Hex?

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

Upvotes: 3

Views: 1984

Answers (1)

Rafa Guillermo
Rafa Guillermo

Reputation: 15377

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:

Upvotes: 2

Related Questions