Microsoft Office Forums - View Single Post - [Solved] Changing background colour in table based on value.

macropod · 09-28-2020, 07:15 PM

Quote:

Originally Posted by amandalee

Thank you so much, I did try that and it certainly works. How do I go in to change the words and also the yellow colour to orange ?

Further down the same thread is more code for changing the font colour: https://www.msofficeforums.com/103931-post21.html

For orange, you could use code like:

Code:

Const wdOrange As Long = 41215
'...
  .Cells(1).Shading.BackgroundPatternColor = wdOrange
  .Font.Color = wdOrange

or simply:

Code:

  .Cells(1).Shading.BackgroundPatternColor = wdColorOrange
  .Font.Color = wdColorOrange