Prev: ActiveX Command Button - Snap to Cell Boundaries
Next: Excell Cells: Auto Formatting
From: housinglad on 9 Feb 2010 16:02
Hi

I would like to validate cell B27, so that only data can be inputed if there
is a value in cell B16.

Thanks
Dan
From: Bob Umlas on 9 Feb 2010 16:18
In B27, use a custom formula of
=$B$16<>""
but you also need to deselect the "ignore blank" checkbox
(assuming this is xl2003)

"housinglad" <housinglad(a)discussions.microsoft.com> wrote in message
news:8896A8E5-4CE9-42AD-82F3-20077BF87C56(a)microsoft.com...
> Hi
>
> I would like to validate cell B27, so that only data can be inputed if
> there
> is a value in cell B16.
>
> Thanks
> Dan

From: T. Valko on 9 Feb 2010 16:29
>if there is a value in cell B16.

Define "value". Does that mean a number or does that mean either a number or
text?

See if this does what you want...

Select cell B27
Goto the menu Data>Validation
Allow: Custom
Formula: =LEN(B16)
Uncheck: Ignore blank
OK out

--
Biff
Microsoft Excel MVP


"housinglad" <housinglad(a)discussions.microsoft.com> wrote in message
news:8896A8E5-4CE9-42AD-82F3-20077BF87C56(a)microsoft.com...
> Hi
>
> I would like to validate cell B27, so that only data can be inputed if
> there
> is a value in cell B16.
>
> Thanks
> Dan


 | 
Pages: 1
Prev: ActiveX Command Button - Snap to Cell Boundaries
Next: Excell Cells: Auto Formatting