2

I would like to write a script to apply the standard available three color conditional formatting to the cells. Specifically, I would like the HEX codes of the colors Excel uses. I didn't see them listed on the Web.

I only found this question which asks for the RGB values for the 'Good', 'Neutral', and 'Bad' formatting. These are different to the colors used in the 3 color conditional formatting.

tiuq23
  • 113
  • 2
  • 11

1 Answers1

3

In Excel 2016 at least the colors for the cells are:

Red:

  • HEX: #f8696b
  • RGB: (248,105,107)

Yellow:

  • HEX: #ffeb84
  • RGB: (255,235,132)

Green:

  • HEX: #63be7b
  • RGB: (99,190,123)

Since I had to check the values and convert them to HEX manually, I figured I might as well share it.

tiuq23
  • 113
  • 2
  • 11