View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anita Anita is offline
external usenet poster
 
Posts: 71
Default Can I validate a cell only if a certain condition is met?

I have set up a custom cell validation that only allows 10% or less of a sum
in a specific cell to be added in the validated cell. I want to set up a
condition that the validation should only apply if a different cell contains
a value. This would be like an "on" switch for the validation. Is this
possible?
--
Anita