Formula for Alert or Message

Hi all,

First of all thanks for your help every time during our work if wee felt..

I have to prepare invoices daily basis..i have to write name in attached sheet i.e cell D7 and Operator name in G13..some time my boss catch my mistake that this operator is for any other company and some time he catchs that this company is for any other operator..

I have a list as there..kindly advise me if my operator is not equal to my company or my company is not equal to my operator as per my list in sheet 1 than a alert massenge should come there so that i would not continue typing till i correct it..

Is there any validation formula or any other advise..

Thanks in acvance for help

Attachment 59782

Hi tariqnaz2005,

Try this:

Please Login or Register  to view this content.

Cheers,

Place this formula in the cell, where alert should be

Please Login or Register  to view this content.

confirm w/ ctrl + shift + enter

Think u can use data validation...

Hi tariqnaz2005,

Use "Format > Conditional Formatting..." set "Formula Is":

Please Login or Register  to view this content.

for both cells, change colour as desired.

Cheers,

Go Data > Validation choose Custom from dropdown menu, and put there, formulae that ConneXionLost has provided.
then go to Error Alert tab and write desired error alert
Or try this one

Please Login or Register  to view this content.

In short see file

Ifu wanna overview formulas, select validated cell (H13, H14) Go Data > Validation

If everything is OK, please marke thread as solved, and dont forget to add a reputation by clickin on a blue scales...