How to mark duplicate words to red?

[london7871]

How to mark duplicate words to red for all cells in worksheet?

It is duplicated words red red.
to
It is duplicated words red red.

[Maudibe]

London,

Here is the code to do what I think you are trying to achieve

In a standard module:

Please Login or Register  to view this content.

RedFont.png

RedFont.xlsm

[london7871]

Hi Maudibe,

The VBA work for
How about this this

but not for
How about this this?

How to revise the VBA to ignore punctuation?

[Maudibe]

London,

Please add the lines highlighted in blue

Please Login or Register  to view this content.

Note: Using the Replace lines will not change the original value in the cell.

HTH,
Maud

[london7871]

Thanks Maudibe, it's work.

I have another small query:
How to insert image in thread, same as post #2?

[FDibbins]

Instead if inserting images, which not all members can see - and we cant really work with pictures anyway - upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[london7871]

Please advise the steps to "upload a small (clean) sample workbook"?

[Maudibe]

london,

I use the same icon to load both pictures and file

upload.png

[london7871]

Thanks Maudibe for suggestion.

[london7871]

Upon my further checking to VBA, the following words that is not duplicated become red:

Area of footings of railing
We refer to drawing CCE/761/D-05 to 08

Please advise.

[jindon]

Please Login or Register  to view this content.

[london7871]

I want mark duplicated words that is consecutive:
(i.e not for this + this or 3.3e)

[jindon]

Then that should be very simple, wait for your friend.