I have a large amount of data in a worksheet that was hand-entered. I want
to go back through and re-enter the data to double-check if there are any
mistakes. I know that there is a way to set up some sort of masking
worksheet that will compare a re-entered value to a previously entered value,
and if there is a content discrepancy, it will be highlighted of formatted in
some way.

For example, in Sheet 1, cell J9, I have the number "12269". So, if in the
alternate sheet I re-enter "12254", an error would pop up or something. Is
there a good way to do this? Thanks!

Kristen wrote:
> I have a large amount of data in a worksheet that was hand-entered. I want
> to go back through and re-enter the data to double-check if there are any
> mistakes. I know that there is a way to set up some sort of masking
> worksheet that will compare a re-entered value to a previously entered value,
> and if there is a content discrepancy, it will be highlighted of formatted in
> some way.
>
> For example, in Sheet 1, cell J9, I have the number "12269". So, if in the
> alternate sheet I re-enter "12254", an error would pop up or something. Is
> there a good way to do this? Thanks!

Format: Conditional Formatting: Use the dropdown to set criteria.

Good luck.
Susan

If you copy the reentered data into the same worksheet. So you have the
original data in column A and the reentered data in column B. Then just
do a sum in column C "=A1-B1" if all the data in colum C is "0" then
the data in both columns is the same.

Pierre wrote:

> Kristen wrote:
> > I have a large amount of data in a worksheet that was hand-entered. I want
> > to go back through and re-enter the data to double-check if there are any
> > mistakes. I know that there is a way to set up some sort of masking
> > worksheet that will compare a re-entered value to a previously entered value,
> > and if there is a content discrepancy, it will be highlighted of formatted in
> > some way.
> >
> > For example, in Sheet 1, cell J9, I have the number "12269". So, if in the
> > alternate sheet I re-enter "12254", an error would pop up or something. Is
> > there a good way to do this? Thanks!
>
> Format: Conditional Formatting: Use the dropdown to set criteria.
>
> Good luck.
> Susan

Kristen --

It depends whether you want to compare cell-by-cell, or simply make sure
that the 2nd entry is somewhere in the first list.

If it's cell-by-cell, then I'd create the two lists, then use the
=DELTA(cell1, cell2) function. If they're the same, it's a 1. If not, it's
a 0.

If you simply want to make sure that your second set is one of the many
listings on the first list, then use the >Data>Validation tool. Follow the
instructions, and set the list of acceptable entries as the range where your
first list of data is located.

HTH

"Kristen" wrote:

> I have a large amount of data in a worksheet that was hand-entered. I want
> to go back through and re-enter the data to double-check if there are any
> mistakes. I know that there is a way to set up some sort of masking
> worksheet that will compare a re-entered value to a previously entered value,
> and if there is a content discrepancy, it will be highlighted of formatted in
> some way.
>
> For example, in Sheet 1, cell J9, I have the number "12269". So, if in the
> alternate sheet I re-enter "12254", an error would pop up or something. Is
> there a good way to do this? Thanks!
>