Hi
I have a list of staff names which may be in different colums in a table. I then have a list of names in column J. If a name in column J has a blank cell in column K then the name text in the table needs to change colour to identify it. But the names in column J may not match exactly.
Example John Dow in Column J will match John Dow wk1.
Any help would be great.
I have a list of staff names which may be in different colums in a table. I then have a list of names in column J. If a name in column J has a blank cell in column K then the name text in the table needs to change colour to identify it. But the names in column J may not match exactly.
Example John Dow in Column J will match John Dow wk1.
Any help would be great.