Hello All,
Apologies for the multiple posts but I am in search of your expertise as my back is against the wall. I have a spreadsheet that needs to be sorted on Column D (there are column A through N) and over 18k records (rows).
Column D's header is 'Family Name'. I need to highlight in yellow the records that have only one name in it. E.g. Rows 2 and 3 only have 'Regina' while rows 4 through 23 have 'Elizabeth Lastname' and other rows have 3 or 4 words (names). I would need help developing a macro that would highlight the row that has only one word in it.
I'm not sure if this even possible because it is not specific but I figured I've received helped here before.
If any further information Is needed, please let me know.
Fingers crossed.
V/r
JB
Apologies for the multiple posts but I am in search of your expertise as my back is against the wall. I have a spreadsheet that needs to be sorted on Column D (there are column A through N) and over 18k records (rows).
Column D's header is 'Family Name'. I need to highlight in yellow the records that have only one name in it. E.g. Rows 2 and 3 only have 'Regina' while rows 4 through 23 have 'Elizabeth Lastname' and other rows have 3 or 4 words (names). I would need help developing a macro that would highlight the row that has only one word in it.
I'm not sure if this even possible because it is not specific but I figured I've received helped here before.
If any further information Is needed, please let me know.
Fingers crossed.
V/r
JB