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 FormatCFCell Value is: not equal to =A2

Format to a color.

Select A2 and FormatCFCell Value is: not equal to: =A1

Format to same color.


Gord Dibben MS Excel MVP


On Wed, 11 Nov 2009 16:20:01 -0800, 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