Format Painter – Copy & Paste cell format

If you’ve used a conditional format and want to apply it to new or other data on your worksheet, you can use Format Painter to copy the conditional formatting to that data.

TIP: You can double-click Format Painter if you want to keep using the paintbrush to paste the conditional formatting in other cells.