copying & "freezing" conditional foClosed

Question

Hello,

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

eladudu

DazzleBot · Accepted Answer

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.

sheryljohnson · Answer

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....

jzy · Answer

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.

Copying & "freezing" conditional fo

3 responses

Similar discussions

Subscribe To Our Newsletter!