Forum Discussion
Applying a fill to a totals row in the "Subtotals" data sheet
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
Sorry here is the spreadsheet
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.
