Change colours in different tables based on dropdown selections

macropod · #1 08-09-2017, 02:55 PM

You could use:

Code:

Case "High": .Range.Cells(1).Shading.BackgroundPatternColor = 4739264: .Range.Cells(1).Range.Font.ColorIndex = wdWhite

Of course, then you'll probably need to change it back again for all of the others; otherwise you could end up with any other choice having white text if the user changes their mind.

kevinbradley57 · #2 08-09-2017, 03:54 PM

Perfect. Thanks!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Hide/Display of sections of document based on Drop Down selections	turnquistcm	Word	2	05-03-2017 07:05 PM
Best way to load data into a template based on user selections	Timbo	Word	1	11-07-2013 05:14 AM
Contact details entered based on multiple drop down selections	ntropey87	Word VBA	4	04-20-2013 11:19 AM
add values to dropdown selections and calculate	guyhs	Word	7	10-24-2012 05:11 PM
Template: group dropdown selections	mfoe33	Word	0	10-15-2012 02:58 AM