EXCEL FORMAT PAINTER is used to copy the formatting of one cell or range of cells and apply it to another cell           or range of cells.
Example: In this example, we will copy the formatting of cell A2 and apply it to range B2:B5.
Select cell A2
Click on format painter
Select Range B2:B5
Note: The formatting for cells B2 to B5 should match that of cell A2.