Excel中条件格式“样式”的RGB代码是什么? [英] What is the RGB code for the Conditional Formatting 'Styles' in Excel

查看:880
本文介绍了Excel中条件格式“样式”的RGB代码是什么?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

所以这应该是一个容易的,对吧?为什么我无法在StackOverflow甚至Internet上找到它? :)



我有一些单元格,我有条件格式化为Excel的标准坏样式(深红色文本,浅红色填充)。



在另一列中,我有单元格,为我创建了一个条件格式化公式。我也想编写这些以匹配坏风格,但是没有选择使用预定义的深红色文本,浅红色填充。相反,我必须选择我自己的格式,但是我找不到正确的光/深红组合。



有谁知道至少更常见的RGB代码的条件格式?



'好'
'坏'
'中性'

解决方案

嗯...我找到了!



For'Bad'
字体是:(156, 0,6)
背景是:(255,199,206)



对于'好'
字体是:(0,97,0)
背景是:(198,239,206)



对于中性
字体是:(156,101,0)
背景是: (255,235,156)


So this should be an easy one, right? Why can't I find it anywhere on StackOverflow or even on the Internet? :)

I've got some cells that I have Conditionally Formatted to Excel's standard 'Bad' Style (Dark red text, light red fill).

In another column I have cells that I have created a Conditional Formatting formula for. I also want to code these to match the 'Bad' Style, but there isn't an option to use the pre-defined dark red text, light red fill. Instead I have to select my own formatting, but I can't find the correct Light/Dark red combination.

Does anyone know the RGB codes for at least the more common of the Conditional Formats?

'Good' 'Bad' 'Neutral'

解决方案

Ahhh... I found it!

For'Bad' The Font Is: (156,0,6) The Background Is: (255,199,206)

For 'Good' The Font Is: (0,97,0) The Background Is: (198,239,206)

For 'Neutral' The Font Is: (156,101,0) The Background Is: (255,235,156)

这篇关于Excel中条件格式“样式”的RGB代码是什么?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

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