Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What are the RGB codes for the Conditional Formatting 'Styles' in Excel?

Tags:

excel

rgb

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'
like image 456
a76marine Avatar asked Dec 22 '14 22:12

a76marine


People also ask

What are RGB values in Excel?

The RGB color model adds combinations of Red, Green, and Blue to produce various colours. Each component is an integer value 0 to 255.

What are color codes in Excel?

What is color coding in Excel? Color coding in Microsoft Excel is a conditional formatting feature you can use to help specific cells or cell ranges stand out. Conditional formatting is a way that you can create rules that Excel follows to determine when to apply conditional formatting.

What is the color code for conditional formatting?

Light yellow fill with dark yellow text.


1 Answers

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)
like image 198
a76marine Avatar answered Oct 12 '22 14:10

a76marine