highlight subtotal rows with a fill color

  • Thread starter Thread starter Deb Raskob
  • Start date Start date
D

Deb Raskob

I want to highlight the subtotal rows with gray fill color so they stand out.
Can this be done without "pasting" the format from one row to the rest
 
Use conditional formatting, select the table except for the headers and use
something like

Formula is


=ISNUMBER(SEARCH("Total",$A2))


where A2 would be the first cell below the header click format, then pattern
and select grey
then click OK twice


--


Regards,


Peo Sjoblom
 

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

Insert Properties 1
Additonal info into newly created Subtotal row 1
Formatting Alternating Rows with a Color 8
How do I subtotal specific / random rows from a spreadsheet? 1
Subtotals in Excel 2007 TABLES 1
Series fill only copying and fill series greyed out 1
Intercept and Slope of visible rows, please. 0
Subtotals 1

Back
Top