Hi,

So we have a 3 part form with scan codes on them. One part goes out to the customer for them to sign and we receive it back the next day. Right now we manually go through and try to match what we received back vs. what we sent out.

I think we could use conditional formatting to make this process go much quicker. All we would need is two columns. The first would contain all of the previous days data that we’ve sent out. The second column would be where we scan in the returned slips from the customers.

My question is how do I get the conditional formatting to work in real time? Or a better way to phrase it, how do I get it to check the entire column for that value? I can only seem to get it to work if the cell next to it has the same data. I set it up to turn green if it matches and red if it doesn’t, but it only works if the cells are side by side. When we scan the returned slips they will be out of order which is why I need it to search the entire column for the value. Any ideas? Thanks!