Spotting different dates between data with the same ID No.

Hello All

I've an urgent need and for the life of me can't figure it out, although I'm pretty sure it's very straight forward.

I have different versions of a file which are issued monthly. Each version has a constant, which is an ID No., but the date may change and it's the change in dates that I need to be able to identify easily and if formatting can be used to highlight it, even better.

I've attached a simple example and hope that somebody can give me the formula to solve this query.

So, I have a list of ID's with an original date and then the same list of ID's where two of the original dates have changed. I'd like to be able to write a formula that can do this for me automatically.

For your info a file listing ID's and dates is issued to a vendor monthly and they return the same file, but may have updated some of the dates. I need to be able to compare the ID's and if the date has changed highlight this.

I look forward to your help.
Thanks

Hi Lightman,

Is this actually representative of your file? What I mean by that is, are there the same ID numbers in the same order side by side each month and only the dates may differ?

Hi

This is just a simple example and I'd like to say that the ID No's. would always be in the same order, however I can't guarantee this. If there's a formula that can accomodate the ID's not always being in the same order as well that would be very useful.

Thanks

Hi. I've downloaded the file, but it just seems to be my original file. Have I missed something? I simply clicked on the attched file option at the bottom of your post.

Thanks

If you mean my file, then it will look the same, but change some dates in the right hand set of data and see what happens.

To see how it works, highlight a cell in data set two (the ones on the right), go to the home tab, select conditional formatting then manage conditional formatting.
There you will see the formula that makes it work.

Hi Wincon

I've downloaded the file, but it just seems to be my original file. Have I missed something? I simply clicked on the attched file option at the bottom of your post.

Thanks

Excellent. Yes, I've found it now and it works a treat.

Thanks so much, simple yet effective.

Hi Wincon

Thanks, yes I've found it under conditional formatting.

That's very helpful of you, it's greatly appreciated.

Best Regards

Lightman,

Please note that also Winon's solution works in your sample data, if in the real workbook the IDs are not in an identical order this approach will not work.

This is why I used VLOOKUP in my conditional formatting formula.

BSB.