Thread: Validation
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
SJT SJT is offline
external usenet poster
  
Posts: 71
Default Validation
Thank you very much.

"Carim" wrote:

Hi,

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

HTH
Carim


Reply With QuoteReply With Quote