Complicated Duplicate Conditional Formatting Formula Problem, Sample Attached.

I have a spreadsheet with about 50,000 rows, listing invoices paid for the past year and a half.

I have attached a sample file, and here is what I am hoping to do

In Column A, you see a vendor id, and in columns G, I, and J I have the data I need to work with.

In the end, I need the spreadsheet to highlight any cells that are duplicate values for each vendor.

So, if Vendor A has 2 invoices paid on the same day (column G), the cell would highlight. Likewise if Vendor A has 2 invoices with the same invoice number (column I), or 2 invoices with the same dollar amount (column J). So there are three potential areas where a duplicate value may occur, and I need to catch any of those 3.

In other words, if there is an invoice date that appears twice with the same vendor, highlight. If there is an invoice number that appears twice with the same vendor, highlight. And if there is an invoice amount that appears twice with the same vendor, highlight.

I know I can set this up for one vendor using conditional formatting, and then use the format painter all the way down, but we are talking about 50,000 cells and hundreds of vendors.

Is there any way I can conditional format the entire worksheet to do this?


What I am trying to do is similar to this post, but I can't get this answer to work for me.
http://www.excelforum.com/showthread...ight=duplicate

I hope I made my question clear. Thank you very much for your help.

That works almost perfectly, but I notice when putting it into my sheet that, say I have 3 dates that are the same, it only displays on check on 2 of them. It looks like it does that for all of them. It only says check on however many times the value appears - 1. I think I understand why you did it that way, this way the duplicate value is the one that pops, but with the way this data is gathered, the second one appearing down the rows might not be the duplicate, it could be the first.

Other than that, it is working perfectly!

That didn't get it either,

my end goal with this is to get that set up, the use conditional formatting and have it highlight the original cell (i.e. the invoice date) if the cell displays "check"

So I can just tell conditional formatting to highlight if the corresponding cell says check, or the cell below it says check.