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?