the user enters only in J 20 and M20. F20 and U20 are formulas. Guess I
need to read up on "calculate event" - which is a new one on me. Thanx Tom

"Tom Ogilvy" wrote:

so if the user is entering data in F20, J20, M20 or U20, then you could use
a change event to validate their entry or use data validation on those
cells.

--
Regards,
Tom Ogilvy


"Gator Girl" wrote in message
...
Here's the formula in the cell - it derives from entries of hours worked:
=IF(AND(U20=0,(F20+J20+M20)<9.5),10-(F20+J20+M20)-S20,0)



"Tom Ogilvy" wrote:

No, data validation only pertains to entering the data in the cell.

You would probably need to use the calculate event or further explain
what
causes the value of the cell to change.

--
Regards,
Tom Ogilvy

"Gator Girl" wrote in message
...
Can this be done? If so, how?