Question

different between Format painter and Marcos in spreadsheet​

Answer 1

Answer:

Note that once you activate the format painter, you can only use it once. After that, you need to activate it again to use it.

Also, when you select a cell and click on the paint format icon in the toolbar, it copies the formatting. Now, when you select the same size target cell, the exact formatting is copied. But when you select a larger range, the formatting repeats.

And one more thing, you can also use format painter to copy conditional formatting rules as well. In case you have used formulas in the conditional formula when you copy-paste the conditional formatting, the formula references would adjust accordingly.