Quite an open-ended request.

Could you be a tad more specific with the details?

Alert before or after?

Data Validation can alert and prevent users from entering incorrect data.

Conditional formatting can alert users after they have entered incorrect data by
highlighting the data if it does not meet the condtion you set.

Either or both would maybe do the trick.


Gord Dibben MS Excel MVP

On Sat, 22 Mar 2008 13:52:02 -0700, LOST wrote:

I have set up a template composed of various tabs, with financial data.
I need to alert users when they make a mistake, and to show them where is
the error to correct it.
Your input will be greatly appreciated.