warning message

  • Thread starter Thread starter cufc1210
  • Start date Start date
C

cufc1210

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
 
highlight all cells, go to data > Validation.

Select customer from the drop-down, enter =$A1=$B1

Set your warning message and type.

Make sure to ignore blanks so that the user can enter one of the cells
without warning.
 
Data Validation>Custom on column A

=A1=B1

Data Validation>Custom 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
 
Back
Top