|
|
#2
10-17-2014, 10:13 PM
|
||||
|
||||
What if the number occurs on more than one sheet? Besides which, the job could be done via conditional formatting, without the need for code. the conditional format formula for 'red' would be:
=(MATCH(A1,Red!A:A,0))<>"N/A"
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| find function default is not saved | potolok | Word | 7 | 06-02-2014 06:44 AM |
 #REF! Error in calling VBA function disappears when function is copied
|
lcaretto | Excel Programming | 2 | 05-26-2014 07:19 PM |
|
Find and Replace function shooting off screen to the left of the document
|
Mattblack | Word | 1 | 04-10-2014 03:06 PM |
| Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
|
FIND function, where?
|
Yumin | Word | 2 | 04-02-2010 07:16 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode