Setting a particular table cell background color when an option button is selected in Word 2007

		Microsoft Office Forums > Microsoft Word > Word VBA
Setting a particular table cell background color when an option button is selected in Word 2007

FAQ

Thread Tools

Display Modes

03-13-2015, 06:51 AM

gmaxey

Windows 7 32bit Setting a particular table cell background color when an option button is selected in Word 2007

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Location: Brasstown, NC

Posts: 1,621

Code:

Select Case fcnCellText oRow.Cells(lngIndex)
  Case "Y", "Y*"
      oRow.Cells(lngIndex).Range.Select
      oRow.Cells(lngIndex).Range.Shading.BackgroundPatternColor = wdColorRed
 Case Else 'Do nonthing
 
 End Select

You could use a Content Control dropdown "Yes/No"

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to remove background color in a table that isn't there but is there?	pintree3	Word	5	10-27-2014 10:23 AM
Can't change table background color in the header in Microsoft Word 2011	simeon1	Word	0	10-13-2014 11:07 AM
Option Button selected will display text	ksigcajun	Word VBA	7	07-14-2014 09:31 AM
Cell Background Color: Base it on Content of Cell?	tatihulot	Excel	4	08-14-2013 03:24 PM
Change cell color everytime a value is selected in dropdown list	angelica_gloria	Excel	4	01-27-2012 06:47 PM