How do I insert a pop-up box to alert me when numbers are wrong?

[Mallymoo]

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

 

[Fred Smith]

Why not use conditional formatting?

Use a format of:
=a1<>a2
and color it, say, red

The cells which don't match will be highlighted in red

Regards,
Fred

 

[Gord Dibben]

Pop-up messages would involve VBA code.

Without code you could use Condtional Fomatting to color the cells when not
equal.

Assuming we're dealing with A1 and A2

Select A1 and Format>CF>Cell Value is: not equal to =A2

Format to a color.

Select A2 and Format>CF>Cell Value is: not equal to: =A1

Format to same color.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

I'd just use a cell that's in a prominent location.

And put a formula like:

=if('sheet 88'!a1='sheet 99'!a1,"","Two cells don't match message here!")

Format the cell in nice big bold red letters.

 

[Dave Peterson]

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.