Im not quite sure what to put in the title, but heres my problem:

I want prevent people from inputing into a cell if other cells have
been filled in.
A1 has no value
B1 has no value
C1 has X
D1 then cannot have a value because A1:C1 has an X in one of the other
three cells

:: but if you make C1 have no value then D1 would be able to input an X
into that cell, however
then the other cells you would not be able to.

Im assuming you would use data validation, things ive tried is custom
data validation with formulas
such as COUNTA(A1:C1)>2, also tried IFTEXT(A1... i tried a few forumlas
which either did nothing, or didnt allow me to do anything.

Anyone have any idea?
Thanks!
Michael

Hi

Select A
Enter validation formula:
=COUNTA($A1:$D1)<2
OK


Arvi Laanemets


"Z" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Im not quite sure what to put in the title, but heres my problem:
>
> I want prevent people from inputing into a cell if other cells have
> been filled in.
> A1 has no value
> B1 has no value
> C1 has X
> D1 then cannot have a value because A1:C1 has an X in one of the other
> three cells
>
> :: but if you make C1 have no value then D1 would be able to input an X
> into that cell, however
> then the other cells you would not be able to.
>
> Im assuming you would use data validation, things ive tried is custom
> data validation with formulas
> such as COUNTA(A1:C1)>2, also tried IFTEXT(A1... i tried a few forumlas
> which either did nothing, or didnt allow me to do anything.
>
> Anyone have any idea?
> Thanks!
> Michael
>

Works like a charm! thanks!

On Dec 6, 9:21 am, "Arvi Laanemets" <arvilaanem...@hot.ee> wrote:
> Hi
>
> Select A
> Enter validation formula:
> =COUNTA($A1:$D1)<2
> OK
>
> Arvi Laanemets
>
> "Z" <arthursdom...@gmail.com> wrote in messagenews:(E-Mail Removed)...
>
> > Im not quite sure what to put in the title, but heres my problem:
>
> > I want prevent people from inputing into a cell if other cells have
> > been filled in.
> > A1 has no value
> > B1 has no value
> > C1 has X
> > D1 then cannot have a value because A1:C1 has an X in one of the other
> > three cells
>
> > :: but if you make C1 have no value then D1 would be able to input an X
> > into that cell, however
> > then the other cells you would not be able to.
>
> > Im assuming you would use data validation, things ive tried is custom
> > data validation with formulas
> > such as COUNTA(A1:C1)>2, also tried IFTEXT(A1... i tried a few forumlas
> > which either did nothing, or didnt allow me to do anything.
>
> > Anyone have any idea?
> > Thanks!
> > Michael