Question posted 2014 · +7 upvotes
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’
Accepted answer +12 upvotes
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)
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.