Audit Tool

K

Karen

I am trying to develop an audit tool in Excel that when a
certain value is not what it should be (i.e. code 44302
should be 44305, etc.) that Excel comes up with a score or
points off for the wrong answer.

How do I go about this? I have the Excel "Bible" but what
heading should I look under that would address this?

Thanks in advance!
 
A

Ant

go into Data than Validition.
Than just type in what you want it to say when there an
error

Ant
 
Top