linking cells

O

Omar

how can i put a formula or option that would not let a user write in a
specific cell unless he/she writes in another cell...like u cant write in the
2nd cell unless u write in the 1st cell and so on...
 
K

Ken Johnson

Hi Omar,

You can use Data Validation.

Eg to prevent the user typing anything into A2 before A1 has an entry
then...

select A2
go Data>Validation
click on the Allow: down arrow then choose Custom
type in the following formula...

=NOT(ISBLANK(A1))

deselect the ignore blanks option

click OK


If you want A3 to be editable only after A2 has an entry then you can
copy and paste special, validation from A2 into A3

When you want to delete these cell entries you will have to delete
their contents in reverse order (A3 then A2 then A1)

Ken Johnson
 
Top