How to do - B2 is only valid if B1 is zero

D

declaire9

Microsoft office 2007 XL. How do I perform a validation where cell B2 is only
valid if cell B1 is blank or zero. Have read the help text on this including
the section on "what is allowed on the context of another cell". As a result
I tried many different things but cannot get it right (if it can be done).
The data validation only appears to have equal to, greater than, less than
etc., for a field compared to the field being validated. It does not seem to
have the scenario where a field is valid solely on the value of another field
(i.e. if(And(B1<>0,B2<>0),error) ) . Can anybody help me?
 
E

Eduardo

Hi,
go to data validation,custom, enter

=OR(B1="",B1=0)

enter an error alert message
 

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 to do a macro for IF cell b1 is < b3 turn b1 red? 1
How to display a value in say B2 in B3 IF a value in B1 is true 11
Multiple IF statement not working 5
if a1= 5 & b1 is 20 how do I make b1 17 but if b1<18 leave as is 2
Counting if Date1 is after and Date2 is before another date 5
If b1 = 1, then b2 = Yellow 1
Excel In Excel how can I block the contenent of a cell? 0
If formula: if A1 is greater than B1 and A1 is greater than zero.. 2

Top