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

A

Anita

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?
 
W

Wigi

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.
 
A

Anita

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i validate a cell that has a formula 4
How to do - B2 is only valid if B1 is zero 1
Help with Sumproduct searching cell contents 2
Validate if cell use data validation 2
Countif, IF condition is met 2
Formula to validate characters within a string of data in aparticular cell 1
if cell is blank 8
Check Box and Validation of a cell 2

Top