DATA VALIDATION - for data which is the result of a formula
 

Can this be done? If so, how?

DATA VALIDATION - for data which is the result of a formula
 

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?

DATA VALIDATION - for data which is the result of a formula
 

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?

DATA VALIDATION - for data which is the result of a formula
 

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?

DATA VALIDATION - for data which is the result of a formula
 

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?

DATA VALIDATION - for data which is the result of a formula
 

If you just want to validate the entries in J20 and M20, then you can do
that with data validation or use the Change event.

For a general discussion of events see Chip Pearson's page on this topic

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Gator Girl" wrote in message
...
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?