Alert box IF false

  • Thread starter Thread starter Jacob Walton
  • Start date Start date
J

Jacob Walton

I need an alert box to display if one cell in my worksheet does not
equal another. Basically whenever one thing is added to the sheet,
something else must be added too, but people keep forgetting to add
the second item. I have a sum of each of the two items which, if used
correctly, will always equal the same number. If they do not then
someone has failed to enter the second item and an alert box must be
displayed. Can anyone advise as to how I can achieve this?

Many thanks.

Jacob Walton.
 
I don't know about an alert box, but I've used conditional formatting to
change the color of the cell in similar cases.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top