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?
Bookmarks