What is the use or Purpose of format painter in Excel

When you format the text and do the modifications to font, size and color of the text in excel then you need to apply font, size and color separately.

In simple if you like the look of a content then you can apply the same look content in other places of the document.

For example,

I want to have "Arial" text with Size = 12 and green colored text in various places of my document.

In the above example "Student" text with font = "Arial" , Size = 12 and color green and you want to apply the same look to "Format Painter sample text" in the cell B7 then click on "B2" Cell and click on Format painter icon with brush symbol.

Apply the same look at B7 Cell - "Format Painter sample text"

Then the text appears as below.