Highlight column range based on multiple cell string match

Hi,

Thanks to MickG in another post here
https://www.excelforum.com/excel-pro...g-in-cell.html
He solved my original question.

I have decided to open a new post as my question has evolved as my workbook develops and I don't want to waste peoples time changing my mind all the time.

Sample attached shows column L with 5 inputs in rows 6 onward. The macro buttons named Errors & ClearCSV run the report and clear the report.

Clicking Errors and running report shows cells in column L turn red, this is where the TCN reference and A reference don't equal 5 & 10 digits respectively. This works as I originally requested so fair play to MickG.

What I have since realised is that if only one of the reference numbers is present then it doesn't highlight red.

What I am now looking for... and this is an ongoing project so you will probably see it again.

Highlights red when TCN and/or A references don't equal 5 & 10 digits respectively, highlights red if only one ref is present but incorrect, and highlights green if both are present and match 5 & 10 digits respectively.

Also if it could highlight the row from A:L rather than just L

I hope that makes sense.

Regards
Tez

No sample attached...