highlight subtotal rows with a fill color

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
 
P

Peo Sjoblom

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

Additonal info into newly created Subtotal row 1
Formatting Alternating Rows with a Color 8
Series fill only copying and fill series greyed out 1
Subtotal 3
Intercept and Slope of visible rows, please. 0
How do I subtotal specific / random rows from a spreadsheet? 1
Subtotal across a row 1
Nesting SUBTOTAL with SUMPRODUCT? 0

Top