I would like to create a conditional formatting rule so that when a cell (In column A) says 'grand total' I would like that row (up to column F) to be highlighted in bold. Is this possible considering the row may move around?
Thanks