• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pasting conditinal formatted text to new file

B

Benaka

New Member
Hi Excel Experts

I have one question in excel. I am using Excel conditional formatting highlight few cell based on preset condition in master sheet. I need copy paste few selected data to new excel and share with team with same cell and font format as in mater sheet without conditional format.
Please let me know how to do this.

Thanks for the solution in advance.
 
Hi Faseeh

Thanks for the reply.

I have tried above method. I am using excel 2010 version. Let me explain with example.
In master sheet, I have given conditional format for E10. If E10 is equal to D10, E10 font or cell becomes red.
I am sharing data E10 only by copying to new excel file. As there is no value in Cell D10 in new excel file, the formatting for E10 becomes default. I want to retain format E10 red without conditional format in the cell in new file.

I have found turn around method for this in google. If I paste data to word and copy the data back to excel, it is retaining same format without conditional format. But this is little cumbersome process.

Please let me know if your solution works for my requirement. I have tried copy paste special format, but no use.
 
Good day Sam

That's me not reading the OP correctly, not sure how the brain cells read formula instead of CF but mine did.....:(
 
Might be copying it as an image would work, if that fine with Benaka.

You have got an option to copy as image on the excel 2010 ribbon.
Then you can just copy the cellls as image and paste it in a new sheet.

Hope this helps....
 
Hi

Thanks for the VBA link. I did some work around method for my problem.
My master sheet reserved 5000 rows for task entry and 5 columns for task completion date, status, remarks etc. This sheet is shared and user is allowed to update remarks regularly. I usually send report every day 7.00 PM highlighting the changes done by users from previous day for current tasks. Completed task are not shown.

I have created backup sheet in same excel, copy paste the data from master sheet after sending report.
Applied conditional format in master sheet so that any changes from previous day will turn text red in master sheet.
The texts will not be color if we copy this data to new excel file. I was assuming there should be some method in paste special option to get this colored format in new file. You answer has cleared my doubt.

Now I am appying filter by text color red, change text color to red which are actually red by conditional format and paste the same to report. I changing back text color to normal. All these are done using VBA.
I hope next version of excel will have some options to paste special conditional formatted texts.

Thanks Abhijeet for copying image through excel ribbon option. I learn't and implemented same for some other requirement today!
 
Hi benaka..

benaka said:
My master sheet reserved 5000 rows
Click to expand...
This line is confusing me that i should told you this trick or not.. o_O

but this line.. forcing me to share the trick..
benaka said:
and 5 columns
Click to expand...
Still give a try.. funny trick..

* Copy all cells and paste in word..
* Color & Interior color will convert to only color.. :)
* now copy from word & paste in NEW excel..
* all pasted data are now only color.. not conditional color..
 
You must log in or register to reply here.
Back
Top