I would be inclined to use a custom data validation for that. In Cell D1 select
Data -Validation - Custom | =A1 < ""
and uncheck Ignore Blanks.
Change the error message to something that indactes they need to enter a code
Choose Ok.
--
HTH...

Jim Thomlinson


"GordL" wrote:

Does someone know a way to prevent a user from entering data into a cell
unless there is something first entered into different cell. Here is an
example of what I am trying to do.

=IF(A1="",disable data entry in D1,enable data entry in D1)
=IF(A1="",D1="")

The application is a time sheet. I want to prevent a person from entering
their hours until a billing code is first entered. In addition, if the
billing code is deleted then I want to delete the hours booked against it as
well.

Thanks for any tips

Best regards
GordL