Chefsohail
Board Regular
- Joined
- Oct 3, 2020
- Messages
- 90
- Office Version
- 365
- Platform
- Windows
Hi Team,
I need your expertise with a code that can highlight all cells in a row if the cell contains any duplicate statement. The duplication has to be within the cell.
Eg:
I am not sure if this is practically possible in excel. In case if it isn't at least the below alternative will help.
Alternative: A code that can highlight all cells in a row if the cell contains any duplicate words except for articles, prepositions and conjunctions. The duplication has to be within the cell.
I hope the examples above illustrates the requirement. I do not need the remarks column. Only the cell needs to be highlighted.
I need your expertise with a code that can highlight all cells in a row if the cell contains any duplicate statement. The duplication has to be within the cell.
Eg:
I am not sure if this is practically possible in excel. In case if it isn't at least the below alternative will help.
Alternative: A code that can highlight all cells in a row if the cell contains any duplicate words except for articles, prepositions and conjunctions. The duplication has to be within the cell.
I hope the examples above illustrates the requirement. I do not need the remarks column. Only the cell needs to be highlighted.