Changing background colour in table based on value.

amandalee · #1 09-27-2020, 11:46 PM

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 ?

macropod · #2 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

amandalee · #3 09-28-2020, 11:27 PM

Thank you
Yes I am sorry, I did declare I am far from a computer wiz
I have attempted a version of both suggestions Version 1 does not change the colour at all and version 2 comes up with an error as attached. I have also attached the document in case it is easier for you to see. I appreciate your time. Amanda

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Background Word Colour not showing on PDF	phorsley	Word	1	04-24-2020 09:18 AM
Text Background Colour in a Table	Colin Vicary	Word	4	08-08-2019 06:02 AM
Word background colour ignores Windows setting	wiganken	Word	1	07-19-2018 09:25 AM
Changing background colour based on dropdown choice	PLeo	Word VBA	2	08-03-2017 07:40 AM
Trying to clear the background colour from a theme	ezekiel181	Word	1	11-14-2010 07:29 AM