Copying & "freezing" conditional fo

eladudu - Dec 11, 2008 at 05:49 AM
 Trackman51 - Jul 29, 2011 at 12:34 PM

In Excel, I am tryng to copy range of cells that have conditional formatting to another sheet.
is there a way to do so while prserving their actual formatting (and drop the conditioning)?

i'm stuck with this one....:-)

many thanks


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.
Thanks! This worked great.
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
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....
thanks anyway :-)