I need a Macros that changes rows A:P to a gray color, based on if the cell in Column B contains the word "total". The text in row B contains more that just the word "total", such as "smith, john Total". There are also other columns which contain the word 'total' so I need it to only look at column B, and for it to change the color of the entire row.
I know I can accomplish this in conditional formatting, but I need a macros. Thanks!
Bookmarks