Thread: In Excel, how can I require a field to contain data?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default In Excel, how can I require a field to contain data?
Data Validation could be used.

Select B1 and Data ValidationCustom

=COUNTA(A1)0

Add an error alert "A1 must be filled before entering data in B1"



Gord Dibben MS Excel MVP


On Tue, 21 Jul 2009 14:06:01 -0700, mswanson
wrote:


Reply With QuoteReply With Quote