Search : in
By :

Copying & "freezing" conditional fo

Last answer on Jan 27, 2009 10:48:26 pm GMT eladudu, on Dec 11, 2008 10:49:19 am GMT 
 Report this message to moderators

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

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « copying & "freezing" conditional fo » in :
Conditional formating - apply on more cells Show
Copy rows based on a condition Show
Copy rows based on a condition Show Copy rows based on a condition Issue Solution Note Issue How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I've tried almost everything but...
Copy/Paste problems when using Firefox ShowCopy/Paste problems when using Firefox Pushow Adware Extensions It happens that sometimes, Firefox refuse to copy/paste items. Two assumptions can be made: Pushow Adware You have been infected by an adware, named pushow**.dll...
Turning off volume shadow copy ShowTurning off volume shadow copy Short intro How to disable? How to edit the disk space allocated to shadow? Disable the "Previous versions" Short intro Shadow Copy Volume or Snapshot Service or VSS, is a feature firstly embedded...
Copy an entire partition on Vista ShowCopy an entire partition on Vista Issue Solution Issue It is possible to copy the entire partition on your hard drive with the DVD of vista. It is very useful if you want to change your hard drive in order to restore all data....
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Ask your question Reply

1

sheryljohnson, on Dec 15, 2008 10:26:41 am GMT

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

   
Reply to sheryljohnson

2

eladudu, on Dec 16, 2008 1:08:25 pm GMT

Thanks anyway :-)

   
Reply to eladudu

3

 jzy, on Jan 27, 2009 10:48:26 pm GMT
  • +1

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.

   
Reply to jzy
Ask your question Reply
They need your help