I am looking for a VBA script to identify errors at following.
1. COLUMN A: PLEASE HIGHLIGHT YELLOW ANY ROW NOT START WITH RMIRAAxxxxxxxx( X is for 8 digit numbers) OR
RCKIRUxxxxxxxx ( X is for 8 digit numbers)
2. COLUMN C = COLUMN A, HIGHLIGHT YELLOW ANYROW THAT IS NOT EQUAL.
3. COLUMN E TAG SHOULD START WITH Axxxxxx (x for 6 numbers ). HIGHLIGHT YELLOW ANY ROW THAT IS NOT START WITH Axxxxxx.
4. COLUMN H = COLUMN I + COLUMN J. HIGHLIGHT YELLOW ANY ROW THAT IS NOT.
5. COLUMN Q: HIGHLIGHT YELLOW ANY ROW NOT START WITH 0056-XXXX ( X STAND FOR 4 NUMBERS) OR BLANK ROW.
6. COLUMN S: HIGHLIGHT ANY ROW WITH WORD " Unclassfied" or BLANK ROW
Attached is the sample file.
Please help. Thank You in Advance !