Validation

[Denise]

I have a workbook that is used by multiple people. There are 5 cells where times are entered. There seems to be a problem that people can't enter the right times. I have formulas set up for wait times, so this messes up the results. The columns I have are:

Arrival Time Triage Time Registration To ED See MD Discharge Time

I want to fix it so that if the tirage time is before the arrival time it gives them a warning. Same with the registration, To ED, etc.

How can I do this??

Thanks

 

[Mike Lewis]

You are on the right track with "Validation"

Select Data Validation, choose the "custom" option and
enter the formula:

=E11>F11

Where E11 is the first column,

Then copy this cell across and down as far as needed.

Then go to the "Error Alert" tab and decide if you want to
stop, or just warn them.

Good Luck

Mike

-----Original Message-----
I have a workbook that is used by multiple people. There

are 5 cells where times are entered. There seems to be a
problem that people can't enter the right times. I have
formulas set up for wait times, so this messes up the
results. The columns I have are:

Arrival Time Triage Time Registration To

ED See MD Discharge Time

I want to fix it so that if the tirage time is before the

arrival time it gives them a warning. Same with the
registration, To ED, etc.