Formula for empty cell

[collyer3]

I am trying to put a validation into a cell that would refer to two other
cells. I want to make it so if I try to type text into B9 cell, I either have
to put an X in cell A10 or A13 first. I sure there's a way to do this, but I
can't figure it out. Any ideas?

 

[Max]

Select B9, apply data validation:
Allow: Custom
Formula: =OR(A10="x",A13="x")
Uncheck "Ignore blank" > OK
Test it out ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik

 

[Bernard Liengme]

I cannot think how to do this at the moment with Data Validation.
Others may give you a VBA solution
Meanwhile, how about using Conditional Formatting ?
With B9 as the active cell use this rule: =COUNTA(A10,13)<1 and set a fill
color to alert the user of an error.
best wishes