TJ,

Set the cell shading for the rows before hiding them. If they're
subsequently unhidden, the shading will be there.