What are the RGB codes for the Conditional Formatting 'Styles' in Excel?
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'
For 'Bad' red:
- The Font Is: (156,0,6)
- The Background Is: (255,199,206)
For 'Good' green:
- The Font Is: (0,97,0)
- The Background Is: (198,239,206)
For 'Neutral' yellow:
- The Font Is: (156,101,0)
- The Background Is: (255,235,156)
I imagine that these might possibly be changed with some styling options. But as far as default values go, these are taken from my version of Excel 2010 which should have the defaults.
"Bad" Red Font: 156, 0, 6; Fill: 255, 199, 206
"Good" Green Font: 0, 97, 0; Fill: 198, 239, 206
"Neutral" Yellow Font: 156, 101, 0; Fill: 255, 235, 156