[Solved] Maintaining Conditional Formatting while Pasting

[Wallypop]

Hey experts,

Just a simple question here. I have a set of cells with conditional formatting (colour changes based on range of the number in the field) and I'm trying to copy and paste a table from a website in to these fields. The issue that I am having is that the cells themselves won't hold the formatting even though the table pastes in to all of the right spots. I have tried using unformatted text and just pasting it as plain text but it still kills the conditional formatting.

Is there a way I can get this to work? I've looked around and have seen some suggestions and tried them, but none that I've found have pertained to this particular situation. Thanks.

[FJCC]

I just tried setting up some conditional formatting that changes the cell background to red if the cell value is greater than one and then pasting two columns of web data as unformatted text. I used Paste Special. The conditional formatting survived after the paste and worked correctly. Could you post an example document and a link to the data you are trying to copy?

[Wallypop]

So for example, I want to use the attributes tab and under the AHL roster paste the AHL players from the following link:

https://dl.dropboxusercontent.com/u/210 ... s/DET.html

The ones I have in there currently I did manually, but I want this to be quick, easy, and painless. Thanks!

[coray80]

I don't think you can, but if you keep a line of the formatting handy like in the attached then...

highlight the cells F1:U1
click the paintbrush icon (between the clipboard and undo icon's)
drag the paintbrush curser over the cells F5:F24

Easiest work around I know.

[Wallypop]

I figured it out myself with a little bit of tinkering. All I had to do was Paste Special and select Recognize Special Functions. Thanks anyway, guys!