Use Format Painter Multiple Times

December 6th, 2004 | Categories: Formatting | Tags:

To copy the format from one cell to multiple places, without repeatedly needing to click the Format Painter icon:

1.Select the cell
2.Double-Click the Format Painter Iconpaintericon
Note: This will keep the paint brush next to your cursor: painterpointer

3.Click every cell you want to copy the format to

4.When finished, click the Format Painter icon again or hit ESC to remove the paint brush from your cursor

  1. Larry White
    May 28th, 2005 at 08:21
    Reply | Quote | #1

    Thanks for the tip. I use the format painter a lot and nowit will be even easier.

  2. May 28th, 2005 at 11:37
    Reply | Quote | #2

    I used it for years, going back and forth…yep, that one is handy.

  3. hari
    October 16th, 2008 at 19:57
    Reply | Quote | #3

    amzing… always had a yearning for doing this with macro…great tip

  4. Lee
    February 23rd, 2010 at 15:18
    Reply | Quote | #4

    I appreciate the tips and shortcuts.

    I’m trying to find how to copy from one cell which has cell value conditional formatting and formula based conditional formatting and paste or paint the formatting to other cells and maintain the integrity of the formula based conditional formatting. For instance, I want to display a color change in each cell based on its value being greater than 23 and I want to change the border color if there are more than 3 blank cells from which the sum is taken. I can format the one cell, but when I copy and special paste or paint the formatting, each cell is formatted based on the original formula and not the formula of respective cells. More specifically, I have number values in cells F1 to F9, F10=sum(F1:F9), if(F10>23) format font “Red”, if (countblank(F1:F9)>=4 border color = “Orange”. When I paste or paint the formatting from F10 to cells G10 to BI10, the conditional formatting automatically groups and formats cells F10 to BI10 based on the single formula (countblank(F1:F9). How can I paste or paint so that each cell is conditionally formatted based on a formula respective to it (i.e. BI10 should be based on if (countblank(BI1:BI9)?

    This comes up rather often in various spreadsheets and it’s very tedious to set a separate conditional formatting rule for each cell. I appreciate your help.

  5. lori
    January 29th, 2011 at 18:03
    Reply | Quote | #5

    Thanks for the tip .. you’ve just made a great tool greater!