o I am trying to make a macro to find a specific string of words (Total Revenue and Other Income) in a Income Statement and once it does, it will select those words and bold it. After it does that, any box to the right that contains values will be selected to have "top and thick bottom border" and bold as well



so for example



the macro would find the string and then does this



Please help me, I have more than 100 files that has over 500 lines and I need to do something like this in all of them.