Hi,

I have a worksheet in which I'd like the user to only be able to enter data
into certain cells if the A cell in that row contains a date.

Where the A cell in the row is empty, the user should not be able to enter
any data into these particular cells, although they will be able to enter
data into other cells in the row.

I thought I should be able to use custom data validation to do this,
however I'm a bit stuck on the formula to use.

--
Rhonda Anderson
Cranebrook, NSW, Australia

Add DV with a type of Custom and a formula of

=IF(A1<"",myRange)

uncheck the Ignore Blank box.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Rhonda Anderson" wrote in message
.5...
Hi,

I have a worksheet in which I'd like the user to only be able to enter
data
into certain cells if the A cell in that row contains a date.

Where the A cell in the row is empty, the user should not be able to enter
any data into these particular cells, although they will be able to enter
data into other cells in the row.

I thought I should be able to use custom data validation to do this,
however I'm a bit stuck on the formula to use.

--
Rhonda Anderson
Cranebrook, NSW, Australia

"Bob Phillips" wrote in news:eiqbCrrxHHA.484
@TK2MSFTNGP06.phx.gbl:

Add DV with a type of Custom and a formula of

=IF(A1<"",myRange)

uncheck the Ignore Blank box.


Very helpful, thank you very much.

--
Rhonda Anderson
Cranebrook, NSW, Australia