Hi,
I have to format a bunch of large spshs.
I need to find specific row's based on the content in column A.
For example, find "Tom" in col A and highlight the entire row light green.
"Tom" is in a merged cell and I want to highlight, his row as well as the 5 rows below it.

It would be great if I could find a couple at the same time and do the same formating.
Exp, Find "Tom" or "****" or "Harry"

In addition,
I need to add a Page Break based on finding content in Col A
Finally I need to add a Bottom Border (heaviest) based on specific cell content.

Thanks for your help.
Jason