Can I validate a cell only if a certain condition is met?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Yes, that's possible.

In the Data Validation screen, you have a Custom option, where you can enter
a formula. Use it to represent your condition.
 
I am using the custom formula. Now I only want this validation to apply to
the cell if I have not entered a value in another cell. Is this possible? I
can e-mail an example.
 
Back
Top