Forum Discussion

Eckbert Gevers's avatar
Eckbert Gevers
Copper Contributor
Dec 14, 2017

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 ...
excel
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Dec 14, 2017

    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.

Resources