Validation Help
 

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

Validation Help
 

In B27, use a custom formula of
=$B$16<""
but you also need to deselect the "ignore blank" checkbox
(assuming this is xl2003)

"housinglad" wrote in message
...
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

Validation Help
 

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 DataValidation
Allow: Custom
Formula: =LEN(B16)
Uncheck: Ignore blank
OK out

--
Biff
Microsoft Excel MVP


"housinglad" wrote in message
...
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