Formatting Within Table Row

[whitecat]

MS Office Word 2003.
I have been spending all this week (4 days total) trying to format my table
containing rows - to show totals on a survey. Sample of one row (please note
- row does not copy/paste to this question forum so assume one row of cells
across Word document with the following cells):
-->No wait
-->1 to 10 minutes
-->11 to 20 minutes
-->21 to 30 minutes
-->31 to 60 minutes
-->More than 1 hour
These are waiting times in doctors' offices. I want to total patient
surveys for each category within the cell. No wait cell up to 20 minutes
cell needs to each be followed with a numerical character showing a total in
bold green (yay!) in each of its cell. Wait 21minutes to more than 1 hour
needs to each be followed with a numerical character showing a total in bold
red (boo!) in each of its cell. I am totaling 1,050 data points for a
practice of 69 doctors so I want to re-open a blank document (template) 69
times to enter individual survey results for each doctor and have the
conditional format always populating bold green or bold red. I have 15
questions with a row of various cells for each quetion needing this
operation. Thanks!

 

[Doug Robbins - Word MVP]

It is not clear from your post where the sub-totals should appear

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[DeanH]

This sounds like a job for Excel, where all the functions and a lot more that
you can use in this exercise are available.
All the best
DeanH