VBA help - highlight "total" rows.
Posted by David Morris on January 07, 2002 8:24 AM
I get daily reports that list hundreds of items in several different groups. The database exports into Excel with a "total" line at the top of each section.
Is there a VBA that will search for all cells that have "total" in a certain column and then highlight a certain range of cells in that row? What I want is to highlight the totals rows in green.
Sorry for the strange wording. I am completely new to the whole VBA deal. Not sure if I am explaining it right.