Highlighting Subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can you quickly highlight with color the rows in subtotals in Excel?
 
Use the outlining symbols to show just the subtotals.

Then select that range.
edit|goto|special|visible cells only

format the visible cells the way you want.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quick/efficient way to VBA subtotal 2
Subtotal - Additional Formulas based on Subtotal range(s) 6
Need to combine two working formulas - not working. 2
Collapse subtotals? 6
Subtotals 5
Count of Font Format 1
>3 Conditional Formats 3
can't use Subtotal when table is madewit menu ADD, Table. 3

Back
Top