[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

"whitecat" wrote:

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!





--
Wishing you all the best!