It just copies the formatting applied on one cell (including conditional formatting) to another cell or range of cells.Ĭlick on the cell whose formatting you want to copy, click on Format Painter icon and you can see pointer changes to the paintbrush, then drag the paintbrush to cell or range of cells where you want to copy the format. The Format Painter is available in the clipboard section of the Home Tab. This will not affect your dataset at all, but you can easily copy the conditional formatting rule to your targeted dataset.
Second approach – format painterĪnother approach that will only copy the conditional formatting rule from one cell to another cell or range of cells is to use the format painter approach. So this approach may not be useful all the time and you may feel it more troublesome to edit the values again. To do this, highlight the cell you want to copy, and hit the Copy button on the Home tab or Control-C, and the go to the target cell and hit the Paste button the Home tab or Control-V.īut this approach will not only copy the conditional formatting rule but also copy the value, which is not required in many cases. One approach is to copy the value from the cell whose formatting you want to copy and paste it to the target cell or range of cells. Copy and paste conditional formatting to another cell First approach – simple copy/paste You can easily copy the conditional formatting rule applied on one cell to other cell or range of cells by using one of the following approaches. Conditional formatting allows you to copy the format of a cell to another cell or range of cells.
0 kommentar(er)
