How do I highlight a row containing certain key words
I have attached my spreadsheet for reference. I have a common spreadsheet with formulas. It contains a macro that 1)removes totals; 2)set filter; 3)sort A; 4)sort C highest to lowest; 5)add subtotals: and last 6)remove filter. Crtl-t is used to activate the macro.
This is what I still want to do. Highlight the subtotal rows (or columns A-P) AND insert a blank line under the subtotals.