Mr Paul,

Now my logic has been chaged... if any text replaced is one time in document then will be red and if more then one time then that will be yellow for all..... this is in my code i think you did not see that...

Your This code is working like my first logic for the red and yeallow color...and also there is some format issue in your code in my ms word line three text "probability of deletion (Pd)"

Now i have apply you code in my doc VBA project....

Pelase check the attached files and run...then you will find the line three problm and color code change...

and Third logic is which used in my code.... if text is

Visual Basic (VBA) in MS word and i have to change Visual Basic to VBA then it will be after replace
VBA (VBA)

but i need only one VBA... so if it is VBA (VBA) then again should be replace by VBA only..

Then final result is

VBA

Attached Files

	Command_New_New.doc (56.0 KB, 10 views)
	Excel Data.xls (39.5 KB, 9 views)