Ask Your Question

how to find a duplicate input

asked 2017-04-27 09:31:50 +0200

_dave gravatar image

Sometimes I have to audit parts that might have the same number. What I need is a way to "see" if I have already inputted a value. I scanned a bar code value into column A. As I scan the next value I need to check if that value has already been entered and if so (conditionally) turn red. Is there an easy way to do this?

Thanks ahead for any suggestions in doing this.


image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-04-27 15:55:55 +0200

JohnSUN gravatar image

Of course you can do it with Conditional Formatting Double

edit flag offensive delete link more


Very good solution, I voted it. gravatar ( 2017-04-27 16:09:15 +0200 )edit

John, Thank you for the answer. This is just what I am looking for. You just made my job easier.

_dave gravatar image_dave ( 2017-04-27 16:38:48 +0200 )edit

I don't see how I can vote for this? Sorry John -

_dave gravatar image_dave ( 2017-04-27 16:43:12 +0200 )edit

You can vote it with ✔ on the left of answer area. gravatar ( 2017-04-27 18:19:54 +0200 )edit

When I re-open, I have to do the condition all over. Is there a way to "keep it", so it will always work when it is being used?

Charlie, thanks

_dave gravatar image_dave ( 2017-04-27 18:40:00 +0200 )edit

Perhaps the Office update to the latest version will remove the problem?

JohnSUN gravatar imageJohnSUN ( 2017-04-28 09:43:46 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-27 09:31:50 +0200

Seen: 350 times

Last updated: Apr 27 '17