I have a table that has conditional formatting (shows how much a number has gone up or down with an arrow each week). I need to paste that table, with the formatting into Word. I'm sure I did it once, but it doesn't seem to work anymore. I have been pasting it as a picture, I'd rather not do that because it doesn't look quite right. I am using Excel 2010. (Though I do have access to 2013 if that would make a difference).

I've never tried pasting conditional formatting into Word, but I'd guess that Word doesn't know what to do with it. But then, Word' doesn't need to, does it? If conditional formatting in Excel causes some cells to be bold, or a different font or color, then that's how it'll look when it's copied into Word, right?

But you said the conditional formatting is an "arrow". I'm not sure what you mean. Is it a graphic, or a dingbat, or what?

This is what it looks like. The arrows are the conditional format. They don't copy over.

Attached Images

cond.png (5.7 KB, 16 views)

Ok, so it's a graphic. I've a notion that the problem isn't that the arrow is produced by conditional formatting in Excel, but that the graphic doesn't cut-and-paste well from Excel to Word. Try this to test: Copy the value of one of those cells to some new worksheet where no conditional formatting has been set, and trying copying that to Word. My guess is that it'll fail in just the same way.

If so, it isn't a solution, but it helps identify the problem correctly. Then maybe someone else will know how to solve it.

Hmm, wait, I'm having second thoughts. Is it a graphic? How do you format the condition? Where is the arrow coming from?

It's not a graphic. I use the conditional formatting found in the Home Ribbon. I'm enclosing a screen shot of the rule.

Attached Images

Capture.JPG (55.0 KB, 17 views)

Oh, icon sets! I didn't even know those existed.

...And I strongly suspect that Word doesn't, either. Still, I think my earlier advice would be diagnostic: If you set up a cell with a value and that icon without conditional formatting, and then copy a range including that cell to Word, I'm betting the arrow icon won't make the move in that case, either. If that's the case, then the problem isn't conditional formatting per se but rather how to copy icons from Excel to Word.

I don't know the answer to that question either, but the first thing is to figure out what is the cause of the problem.

Not sure I understand. The icon is created by Excel. I don't add the icon at all. So I don't know how to set up a cell with the icon.

I assumed that the icon could be produced by some means other than conditional formatting, but since I wasn't even aware of icon sets before that's just an assumption. Let's see what I can find out by searching in the Help files.... Well, it looks like those icons are related only to conditional formatting; I probably can't create one of those icons just as a value in the cell, in other words. I didn't expect that, but I think it means you can't get the table into Word.

A possible workaround: You can take a screen shot of the important part of the worksheet and paste it into Word as a graphic. Not what you wanted, I know, but maybe it could be good enough in a pinch. Maybe someone else can come up with a better idea, but I'm out of good ones myself—sorry.

Thank you for trying.