Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google sheets custom number format, color specification

I have a customized number format for my percentages. Here is the code:

[Green]#,##0.0%;[Red](#,##0.0%)

Output preview:

Positive:   123,456.0% # Green
Negative:   (123,456.0%) # Red

I want the Green to be darker, I've tried [Dark Green], [Dark_Green], [dark green 1] (from Google's fill color drop down), and even hex codes [#00ff00] for Green, none of them work.

like image 780
jason Avatar asked Jan 10 '23 10:01

jason


1 Answers

Try this:

[Color10]#,##0.0%;[Red](#,##0.0%)

For more information goto https://support.google.com/docs/answer/56470?p=drive_custom_numbers&rd=1

like image 186
nwill001 Avatar answered Jan 17 '23 11:01

nwill001