Setting a particular table cell background color when an option button is selected in Word 2007
Hi everyone,
I have a table (7 columns and 90 rows) with 90 questions each question in a row.
In each row: the question comes in col 1, and in col 2 comes a radio button for Yes, and in col 3 a radio button for No. Then in only some of the last 4 cells on the right there is a "Y" letter. Those cells are either empty or have the letter Y in them.
I named the option buttons as e.g. for first row/ question: OptionButton1y for the Yes button and OptionButton1n for the No. I also grouped each two option buttons in each row in a separate group called Q1, Q2....etc. (Note: creating those buttons made the doc take ages to load when first opened ! )
What I need to have is :
When a NO option button is selected in any row (question), a macro looks if any of the last 4 cells in that row has a Y in it and if so to change the cell color shading to red.
I need this to occur with each NO selection on each of the rows.
I hope someone can kindly help me with this.
Thanks so much in advance
|