Thread: If A1=X cell d1 must be completed before row 2 can be used
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
liuyann liuyann is offline
external usenet poster
  
Posts: 1
Default If A1=X cell d1 must be completed before row 2 can be used
hi , you can add the data validation for the rest cells
or you can add some VBA code in the selection_change event


"Paul07" wrote:

If the text in cell A1 = Cheque then other cells in row 1 need to be
completed, one of which must be cell D1 which will contain the cheque number
before allowing row 2 to be used.
Reply With QuoteReply With Quote