Thread: Validation Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas[_3_] Bob Umlas[_3_] is offline
external usenet poster
 
Posts: 320
Default 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