Partial duplicate - Sumproduct VBA Help!

Hi Rory,

Many thanks for the rapid response, That fix has gotten the formatting doing what i had hoped.

The next issue is it seems my blank cell format stop is not working.

(I also had to make all arrays start from $E$9 due to the initial section of code!)

Please Login or Register  to view this content.

This is first in the list of the macro. And from my knowledge of how the standard function works this should mean cells which are blank should not be considered further.
Also apologies for not using the appropriate tags!

Kanage

The aim is to rectify the fact that the duplicate formula identifies blank cells as duplicates. (Even with

Please Login or Register  to view this content.

being included!)

As such the 1st conditional format is intentionally left blank, effectively to trick excel to leave the cell alone. With the Stop if true value meaning the later conditional formats are not run.

At least that's my logic on the approach, and a work around i have used without VBA previously.

Img below highlights the colouring issue on blank cells.

CondFormat example.PNG

Thanks for your patience!

That's a much better way of going about it! I got so caught up on trying to get the formatting to work i didn't think to expand it! now just to flip this on its head to highlight new clients and the sheet is up to scratch again!!

Many thanks for your help today!

now just to find the solved button.