find the word and highlighst vba extention

Colin Legg · #1 03-15-2012, 02:44 AM

I have attached a workbook with two conditional formatting examples.

Example 1

will hightlight E3:M31 if any of the cells have an exact match to any word listed in A3:A20. The conditional formatting formula is:

=OR(E3=$A$3:$A$20)

Example 2

will hightlight E38:M66 if any of the cells contain any word listed in A38:A55. The conditional formatting formula is:

=OR(ISNUMBER(FIND($A$38:$A$55,E38)))

This is case sensitive. If you do not want it do be case sensitive then use SEARCH() instead of FIND().

gsrikanth · #2 03-15-2012, 03:13 AM

Quote:

Originally Posted by Colin Legg

I have attached a workbook with two conditional formatting examples.

Example 1

will hightlight E3:M31 if any of the cells have an exact match to any word listed in A3:A20. The conditional formatting formula is:

=OR(E3=$A$3:$A$20)

Example 2

will hightlight E38:M66 if any of the cells contain any word listed in A38:A55. The conditional formatting formula is:

=OR(ISNUMBER(FIND($A$38:$A$55,E38)))

This is case sensitive. If you do not want it do be case sensitive then use SEARCH() instead of FIND().

example 2 is suitable for me but where to put formula i have hundred words

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word VBA - Find	SDondeti	Word VBA	4	08-15-2012 05:03 PM
Bad view when using Find and Find & Replace - Word places found string on top line	paulkaye	Word	4	12-06-2011 11:05 PM
find&replace word in uppercase with word in lowercase	andrei	Word	3	10-03-2011 05:11 AM
where we can find the meaning for all the marks that Word uses?	Jamal NUMAN	Word	2	06-26-2011 09:49 AM
How to find out the version of the word files?	mariaprabudass	Word	0	06-18-2010 05:40 AM