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.

"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