Formula for empty cell
 

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?

Formula for empty cell
 

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
---
"collyer3" wrote:
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?

Formula for empty cell
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"collyer3" wrote in message
...
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?