['Select the cell with the formatting you want to copy.', 'Select Home > Format Painter.', 'Drag to select the cell or range you want to apply the formatting to.', 'Release the mouse button and the formatting should now be applied.']