Nevermind :) I was able to find my previous answer from a year ago! Thanks!

"Jennifer" wrote:

I used to have a macro that would change a row color to pale yellow if the
first cell contained the word "total". I cannot locate that macro and I've
searched the archived questions. Would someone help me?