Or, use Home Clipboard Paste Formatting (R). To copy only the formatting (including conditional formatting), use the Paste Special dialog box and select the Formats option. As a result, when you copy a cell that contains conditional formatting, you also copy the conditional formatting. This range uses data bars, color scales, and icon sets.Ĭopying cells that contain conditional formattingĬonditional formatting information is stored with a cell much like standard formatting information is stored with a cell.
0 Comments
Leave a Reply. |