VBA code to highlight row where column contains specific text.

Hi Guys,

I have created a macro that for colleagues that identifies when data in a worksheet needs amending. A message box pops up to let them know there is an error. I would like to assist them more by highlighting the rows where the data needs fixing.

Column C contains an IFERROR formula that brings up text "Transaction ref doesn't match client ref" if there is an error.

Could anybody help me with some code that would highlight rows where column C contains the word "match". The cell will contain other text as well as the word "match".

Thanks in advance.

Conditional formatting seems the best solution but you could also assist them by selecting the row that has a mistake.

Apperently you have a code already that finds the mistake and informs them with a message box
you could ask them then if they want to check the errors now and simply select the row that created the error.

Thanks for the comments.

The workbook is created from scratch in the macro so conditional formatting can't be set up beforehand. There could be multiple errors in the workbook so I'm not sure how to select the rows that have errors.

Thanks for you contributions guys but I figured it out.

Please Login or Register  to view this content.