Link to home
Start Free TrialLog in
Avatar of 3wits
3witsFlag for United States of America

asked on

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.

Can you help?
test--8-5-11.xlsm
Avatar of ukerandi
ukerandi
Flag of United Kingdom of Great Britain and Northern Ireland image

check this one
test--8-5-11.xlsm
ASKER CERTIFIED SOLUTION
Avatar of JP
JP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 3wits

ASKER

I've requested that this question be deleted for the following reason:

found my solution
Avatar of 3wits

ASKER

I found my solution
I dont agree that the question should be able to be removed after a working solution has been provided.
I dont agree that the question should be able to be removed after a working solution has been provided.
The first comment addresses only one of the two requirements.

The second and third comments each address both comments.
Points may be split between #36321455 and #36321492
Why split the points if the second addresses both concerns and the third was submitted over 20I minutes later.
Splits are done with even larger time gaps.

Besides the two which address both issues do so in different ways. Any one may be preferred over the other. The OP is the best judge for the choice. That is why I suggested a split.
Avatar of 3wits

ASKER

I'm sorry for the problems this has caused.  I just registed for this site 2 days ago and I guess I was not aware of how it worked.  I actually deleted the question because I received the answer on another question from dlmille that also answered this question.  However, it was a separate question. You are correct, the first comment only answered part of the question and the 2nd and 3rd answered completly.  I will make sure I do things correctly the next time.