Google表格自定义数字格式,颜色规范 [英] Google sheets custom number format, color specification

查看:82
本文介绍了Google表格自定义数字格式,颜色规范的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我为百分比设置了自定义数字格式.这是代码:

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

[绿色]#,## 0.0%; [红色](#,## 0.0%)

输出预览:

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

我希望绿色变深,我尝试过 [深绿色] [深绿色] [深绿色1] (从Google的填充颜色下拉列表中),甚至是绿色的十六进制代码 [#00ff00] ,它们都不起作用.

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.

推荐答案

尝试一下:

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

有关更多信息,请访问 https://support.google.com/docs/answer/56470?p = drive_custom_numbers& rd = 1

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

这篇关于Google表格自定义数字格式,颜色规范的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆