How do I insert a pop-up box to alert me when numbers are wrong?
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
|