Hmm.. I don't think this will be your final answer, however I could conceive
that you use one of the default functions on the sheet that deals with
changes in cells. If the data in a cell changes to a value that does not
meet your validation criteria, you store the row of the change. Then if the
user tries to select a different row to be active, the user is alerted and
the activecell becomes a predesignated column in the row that is a problem.
The user should be informed how to get around this if they need to select a
different cell for data review.

Not the program to do it, but it's the idea you are looking for, I think.


"Kathy - Lovullo" wrote:

I am working on enhancing our expense report to require the users to enter a
code in a specified cell if the dollar value of certain cells is greater than
zero.

Column E contains the code that will be required if any expense amounts are
entered in columns L thru Q of that same row. I would like to validate each
row before proceeding to entering the next row. This validation needs to
be run on 20 rows.

Any suggestions would be greatly appreciated.