Here is what I need to do: I need a macro to find order#"s that begins with W9 and highlight the entire number in red. Here is the problem. I need to search a large worksheet(about 500 rows daily) and highlight the entire words so it looks like this :" ORDER# W944287 - TRANSFER TO MPK". The number will always be 6 digits ,begin with W9 and will be located in column H. Any help will be appreciated.
Thanks
Bookmarks