Applying a fill to a totals row in the "Subtotals" data sheet

[Eckbert Gevers]

Hi I have an excel sheet with various entries. I need to get the daily totals for each transporter. I have included the excel spreadsheet.

I would like to fill each subtotal row with a color. This will make it easier to zoom in and avoid looking up the incorrect values.

I can insert a table style, but this will shade only alternative rows. Is there a way in doing this in excel. ?

In the spreadsheet I have highlighted the total rows.

Thanks for your help. Eckbert

[#2]

Sorry here is the spreadsheet

[#3]

Hi Eckbert,

As variant you may check in conditional formatting rule if word Total exists in your Transporter column to highlight such rows

=ISNUMBER(SEARCH("Total",INDIRECT("Table1[@Transporter]")))

and apply the rule to your entire table.