Thread: [Solved] Change colours in different tables based on dropdown selections
View Single Post
 
Old 08-09-2017, 02:55 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote