warning message
Data ValidationCustom on column A
=A1=B1
Data ValidationCustom on column B
=B1=A1
Add an input message and/or error alert message informing users of the
limits.
NOTE: if you enter a number in A1 and B1 is blank you will not get a message
Gord Dibben MS Excel MVP
On Wed, 30 Sep 2009 12:59:02 -0700, cufc1210
wrote:
last time ill be asking today i promise
I have two columns eg A and B where figures will be entered they must match
Eg
A B
1 5 5
2 1 2
3 4 4
If the numbers dont match like in row A2 and B2 is there a way of gettinng a
warning message box telling them. then they will have to press ok to continue.
Thanks
|