The trick is the Format Painter tool; it's on the Home tab and looks like a paintbrush. Select the cell you like, click the paintbrush icon, and then click on a different cell to paint in the ...