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.
dave