|re: "I want to highlight several rows and find that same text in the other excel spreadsheet."|
I'm not sure what you mean by that.
Typically Find or any of the lookup formulas will search for a word or a string or a value but not "several rows".
Please tell us what are you trying to do in a little more detail.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.