Hello,

Was hoping this would help me, but none of the above formula are working...

I have several columns of data with duplicate numbers (both positive and negative) and I want to be able to highlight one anywhere there is a dulpicate.

As an example in the attached spreadsheet I'de like cell G11 and L10 to be highlighted as they are the same value (plus any other cell that matches that figure) - but that isn't the only amount I need to highlight - F15 and L14 should also ping.

Basically I need to have a formula that will search all the figures in columns f:l and highlight any there are multiples of regardless of if they are positive or not.

As a forewarning - I'm awful at Macros, so would like to avoid if I can.

Thanks

Source 1 Source 2 Source 3 Source 4 Source 5 Source 6 Source 7
1,466.94
4,500.00
108,487.50
9,100.00
2,500.00
27.95
27.95 -27.95
15,000.00
-15,000.00
15,000.00
31,386.25
8,930.00
-8,930.00
8,930.00