Related:
- Copying & "freezing" conditional fo
- Protect pdf from copying - Guide
- Copying data from one sheet to another - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Usb drive disappears when copying files - Hardware Forum
- Call of duty modern warfare freezing - Call of Duty (CoD) Forum
3 responses
I don't think you can do it within Excel without using VBA. However a quick work-around is to copy/paste the table into Word, and then copy/paste it back into Excel. All formats are preserved as shown on screen but are no longer conditional.
I'd copy the cells w/ all the formatting, then delete all the conditional formatting that you don't want by going to Home Tab -> Conditional Formatting ->Clear Rules.
sheryljohnson
Posts
5
Registration date
Saturday November 1, 2008
Status
Member
Last seen
December 15, 2008
4
Dec 15, 2008 at 05:26 AM
Dec 15, 2008 at 05:26 AM
I tried to do it with copy - and then paste special: format, but it doesn't work (it copies the conditional formatting rules too, and not the appearing format only).
I believe that what you're trying to do isn't possible....
I believe that what you're trying to do isn't possible....
Jul 29, 2011 at 12:34 PM