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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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