-
How to Use the Format Painter Selectively
I have in cell A1 formatting that includes both conditional formats and “permanent” formats (like font size and number or date formats). I would like to copy all formats EXCEPT conditional formats from cell A1 to a bunch of other cells leaving their conditional formats unchanged. Can that be done or does Format Painter copy all formats no matter what is present?
SId
-
Hi Sid,
You could create a Style base on the first cell. This does not transfer the conditional formatting.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules