What does the Format Painter button do in Excel?

It enables you to copy the format you have used in one or more cells, and apply it to other cells. A cell using a combination of formatting can have all of its formatting applied to other cells, without having to apply the individual settings one at a time.