The format painter lets you copy all of the formatting from one object and apply it to another one – think of it as copying and pasting for formatting. Select the text or graphic that has the formatting that you want to copy. Note: If you want to copy text formatting, select a portion of a paragraph.

Does Format Painter copy conditional formatting?

To extend your conditional formatting to a new part of the spreadsheet, a new worksheet or even a new workbook, Excel's “Format Painter” feature lets you easily copy conditional formatting.

What is difference between copy and format painter?

When you press "Control-C" or click the "Copy" button on the Home tab, the computer copies the selected text into the clipboard. ... Format Painter picks up all the formatting from your first thing, whether it's a shape, cell, picture border, or piece of text, and applies it to the second.