Thread: Validation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Validation
Hi,

Yes with Data Validation
Allow Custom
Formula =SUM($A$1:$F$7)=1

HTH
Carim

Reply With QuoteReply With Quote