--

HTH

RP
(remove nothere from the email address if mailing direct)


"RagDyeR" wrote in message
...
Duhhhh !!! <g


"Ray A" wrote in message
...
RD
Uncheck the ignore blank box then it worked for me
HTH

"RagDyeR" wrote:

Doesn't work for me Bob, and I'll be darned ... I can't figure out why
or
what else to use?!?!

*Can't* stop B from accepting input when A is blank.

Does it work on your box?
--

Regards,

RD

--------------------------------------------------------------------------
--
-------------------
Please keep all correspondence within the Group, so all may benefit !

--------------------------------------------------------------------------
--
-------------------

"Bob Phillips" wrote in message
...
Use data validation with a custom formula of

=AND(A2<"", B2=A2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"patam" wrote in
message ...

I need to make sure that the date entered in column B is equal to or
greater than column A and that no date can be entered in "b" if "a" is
blank


--
patam

------------------------------------------------------------------------
patam's Profile:
http://www.excelforum.com/member.php...fo&userid=3192
View this thread:
http://www.excelforum.com/showthread...hreadid=401481