With a bit of further thought, I wouldn't allow the users to mess up.

I'd just use a single cell and then the second cell (if I absolutely needed to
have two for some reason) would be:

=if('sheet 777'!a1="","",'sheet 777'!a1)

Try not to give me (the user) a chance to screw up--and I'll screw up less.

Mallymoo wrote:

I would like to have a box pop-up to alert me when two numbers in my
spreadsheet do not match. Can somebody please let me know how this is done?

If that is not possible, I would like to insert a box control that when it
is clicked and the numbers do not match, it will colour them to alert me.

Cheers

--

Dave Peterson