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 ...
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.