|
|
#4
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(). 
|
|
|
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 |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode