Thanks for the reply (I could not download attachment)
I copied the formula on Validation for A1, unselected "ignore blank", and
the problem now is that it *always* restricts the value ..: (

"Bearacade" wrote:


Validation for A1 should be:
=AND(ISBLANK(B1),ISBLANK(C1))

Validation for B1 should be:
=AND(ISBLANK(A1),ISBLANK(C1))

Validation for C1 should be:
=AND(ISBLANK(A1),ISBLANK(C1))

Make sure that Ignore Blank is NOT checked.

I will attach a sample copy for you.


+-------------------------------------------------------------------+
|Filename: validation.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5180 |
+-------------------------------------------------------------------+

--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=570872