Select all the cells where you want the copied conditional formatting to be applied.In the Clipboard group, click on the Format Painter icon.Select the cell (or range of cells) from which you want to copy the conditional formatting.Suppose you have a dataset as shown below where I have conditional formatting applied to the Math score column so that all the cells that have the value more than 80 get highlighted.īelow are the steps to use format painter to copy conditional formatting from the Math score column and apply it to the Physics score column: Copy Conditional Formatting Using Format Painterįormat painter is a tool that allows you to copy the format from a cell (or range of cells) and paste it.Īnd since conditional formatting is also a part of the formatting, you can also use format painter to copy and then paste it. Note: The same steps shown above would also work when copying and pasting conditional formatting to cells in another sheet or even another workbook.
