Colour row but remove conditional formatting

Hi,

The below code is used to Search for a number in a textbox and if found on another sheet it will strikethrough the line and also colour it red.

In addition to this I have conditional formatting that colours lines green if there are any value in columns A, E, L and P but the above VBA doesn't work on rows where this conditional formatting has already confirmed those cells unless I remove an entry from one of the cells.

Is there a way for the VBA to instruct the conditional formatting to ignore these conditions OR when the number is searched and found in the other sheet, it removes the value from column P (as this isn't needed if we are at this point) allowing the strikethrough and row colouring to take affect?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

will remove conditional formatting from a specified range.

Thanks BellyGas, but how do I use this in the script I posted?

straight after the 'set rng.....' put range(rng).clearformats

As in the below? This gives me an error

Capture.PNG

Please Login or Register  to view this content.

My bad:

Please Login or Register  to view this content.

maybe put it inside the if range is nothing statement as it'll error if fnd wasnt found.

Not a problem. So I've now placed this within the IF range is nothing statement and it partially works.

Please Login or Register  to view this content.

It is now striking through the line but it remains green, see screen shot. I need it to ignore the colour formatting too and change it to pink like the ones above.

Capture.PNG