|
|
#6
09-28-2020, 12:05 AM
|
||||
|
||||
You need to look closely at the code and adapt it to your requirements. I'm not sure exactly which code you chose. Colours can be explicitly defined in RGB terms for more flexibility in defining a colour.
An example which would give you orange is Code:
Case "Assisted": .Range.Cells(1).Shading.BackgroundPatternColorIndex = RGB(255,192,0)
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
|
|
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 |
Windows 10 
Office 2016
Threaded Mode