Data Validation Query

  • Thread starter Thread starter Rhonda Anderson
  • Start date Start date
R

Rhonda Anderson

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.
 
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)
 
Back
Top