I have an xls that has multiple worksheets and i need to run a macro that will format certain rows on each sheet. The rows are always different but the columns are all the same B-E on each sheet. The condition to look for is the word "Total", if it has that word anywhere on the row then we need the row to be formatted between Col B-E (Bold and a top line). Is there a good macro that can help us do this? Tried for a week and nothing is working.
Bookmarks