FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -There are two ways to use the Format Painter: Single-click the Format Painter to copy the formatting from the selected cell, then click a different cell to paste the formatting. Alternatively, you can click and drag over a range of cells to paste the formatting to multiple cells.

Detailed explanation-2: -Copy Conditional Formatting Using Format Painter Format painter is a tool that allows you to copy the format from a cell (or range of cells) and paste it. And since conditional formatting is also a part of the formatting, you can also use format painter to copy and then paste it.

Detailed explanation-3: -Format Painter only copies the formatting and not the value in the cell. You can use format painter in Excel to: Copy formatting from the same worksheet. Copy formatting to some other worksheet in the same workbook.

Detailed explanation-4: -Select the cell with the formatting you want to copy. Select Home > Format Painter. Drag to select the cell or range you want to apply the formatting to. Release the mouse button and the formatting should now be applied.

Detailed explanation-5: -Copy conditional formatting from one control to another Select the control that has the conditional formatting you want to copy. On the Home tab, in the Clipboard group, click Format Painter. Click the control to which you want to copy the formatting.