Aug 6, 2025 · Select A1:E7 and copy. Select G1:K7. If you are in Excel 2007 or earlier, use Alt+E+S to display Paste Special. Select Formats and click OK. If you are in Excel 2010 or …

Feb 10, 2016 · I need a code that will take the range of cells from one spread sheet and paste only the formatting to the current sheet. Here's what I have...

Nov 3, 2008 · You can't do what you're trying with formula or conditional formatting. Based on the information you have given us so far, my personal choice would be a range copy with VBA, as …

Jun 5, 2013 · I'm trying to copy cells with formulas in and paste special on another sheet - This works fine - but I need to copy over the formatting too (Colour of cells, size of font etc) but I …

Feb 7, 2008 · Pivot charts are a whole different animal. I wrote a tutorial last year: Working with Pivot Charts in Excel. To link a pivot chart to a different pivot table requires a few steps. 1. …

Dec 10, 2020 · If that's the case, the formatting of the cell within the validation list in column A with the (validated) value is copied onto the just changed cell. In your workbook, right click on the …

Jul 2, 2010 · When doing a vlookup of an existing table, is there anyway to bring the formatting along with the data? For instance, if a cell in the table is red, can this format setting be brought …

Jun 13, 2002 · I have condtional formatting set up so that a cell's (A1) contents are turned red if a formula condition in another cell (B1) returns true. I'd like to copy or fill the conditional …

Aug 5, 2008 · In Excel 2003, is there an easy way to paste borders into other cells on-the-fly without affecting other formatting settings (Number format, Font, Cell Shading, etc) in the …

Apr 1, 2004 · A workaround would be to use Conditional Formatting to change the formatting in both the original and the linked cells. If, for example you want a cell to change colour because …