varify the input in a table

[MikeM]

I have a document that has a table on it. The table has 3 columns and over
12 rows. The first column is a sample, the second is the spec, the third is
for results. the user updates the results I want it to highlight in red if
it is over the specification. I am not sure how this is done.

Thanks,
MikeM

 

[Mark Tangard]

Hi Mike,

This would be about 14 million times easier to do in Excel,
using what the Excelheads call "Conditional Formatting").
Any chance you could use Excel for this instead of Word?
The applicable cell would change color instantly, and the
whole scheme would work without macros, so you'd never have
to worry about the user's security level.

If not, you'll likely need a macro that compares Columns 2
and 3, which the user would need to run when the table --
or each entry -- is complete. Post back if you need that.