Share via

How do you create an alterable RAG (Red, Amber, Green) table in word 2013?

  • Article

Question

Thursday, October 2, 2014 8:34 AM

I have created a RAG table in excel and tried to paste it into word but either the conditional formatting does not transfer across or the excel table has to be opened in the word document. Does anybody know how to create a tidy table in Microsoft word 2013 that has the ability to be altered which in turn will have an affect on the RAG status? 

Any advice would be appreciated.

Cheers

Kyle

All replies (1)

Monday, October 6, 2014 9:08 AM âś…Answered

Hi Kyle,

When you paste Excel RAG chart in Word 2013, you can use Special Paste like the picture below:

For more detail information:

https://support.office.com/en-US/Article/Copy-an-Excel-chart-to-another-Office-program-e6def7a5-ef82-41aa-b3c0-cf512984db5e?ui=en-US&rs=en-US&ad=US

If there is anything else that I can do for you regarding this issue, feel free to post back.

Best regards,

Greta Ge
TechNet Community Support

It's recommended to download and install Configuration Analyzer Tool (OffCAT), which is developed by Microsoft Support teams. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.