Thread: [Solved] Using the find function between sheets
View Single Post
 
Old 10-17-2014, 10:13 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote