Ok, if cell b1 ="SPARE" then I want it to format the whole row in the table Is that possible?