What is the RGB code for the Conditional Formatting 'Styles' in Excel

excel rgb
a76marine picture a76marine · Dec 22, 2014 · Viewed 96.1k times · Source

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'

Answer

a76marine picture a76marine · Dec 22, 2014

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)

Related questions

Set background colour of cell to RGB value of data in cell

I have a column containing RGB values, e.g.: 127,187,199 67,22,94 In Excel, is there any way I can use this to set the background colour of the cell?

Read More
Return RGB values from Range.Interior.Color (or any other Color Property)

I was trying to incrementally change the background color of a cell to black, and I found that the Range.Interior.Color method returns a Long which is seemingly arbitrary. Looking at the documentation on MSDN, there is nearly nothing …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More