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
Bookmarks