11/17/2019 Conditional Formatting In Microsoft Word
Is there a way to apply conditional formatting to a table in Microsoft Word 2010, in much the same way that it is possible in Microsoft Excel?
Active10 months ago
Oct 02, 2019 Hi PaulW912, It is possible using VBA to set Conditional formatting with color in a word table. Click Macros in View tab View macros type in the name, create replace all the content with the following code Save. Example explanation: This can change the color of value value ≥ 0 to yellow, value ≥ 3 to green, and blank cells to white.
Thanks.
SnookerFan
SnookerFanSnookerFan
65244 gold badges1414 silver badges3131 bronze badges
4 Answers
You know, the old Microsoft Office 96 could do this.
Ah yes, why not just insert an Excel spreadsheet.
Hit the little arrow below Table on the Ribbon and voila! Like it's 1 - 9 - 9 - 6. . .
surfasbsurfasb
21.1k33 gold badges4545 silver badges7272 bronze badges
Conditional Formatting in Microsoft Word 2010:
Conditional Formatting In Word Document
Go to 'Replace', click in the box next to 'Find what' and type in your condition. (If your condition is more than just words and/or numbers, check in the 'Format' or 'Special' buttons to see if you can (or need to) more closely identify what you want Word to find.) Then click in the box next to 'Replace with' but don't type anything. Instead, click on the 'Format' button and choose how you want it formatted. Then of course, click 'Replace all'. Please note, this will only work for text already in the document. All future occurrences will have to be 'replaced' again. Please also remember that Word is designed to work with text and probably won't be as good at identifying mathematical variables as Excel.
I hope this was helpful! :)
Dani FarrellDani Farrell
If you are using merge fields, you can do something like this:
And format each field
{} with the color you want.
AndréAndré
1- Just copy your table from excel2- In word: Home->Paste options->Link & Keep Source Formatting
HosseinHossein
Not the answer you're looking for? Browse other questions tagged microsoft-wordmicrosoft-word-2010conditional-formatting or ask your own question.
Viewed 1k times
Question : Is there a way to apply conditional formatting in Microsoft Word ?
Situation : I have a created a table in an Excel Worksheet and then I copy pasted it in a Word document, so it's a pasting option which keeps the link between the table in word and its raw data in Excel but the table keeps the style of the Word document so that I can modify it as I want to.
What I want to do is to apply a color formatting on cells higher than a given target number in some columns.
I found that post but I am not sure on how to do in my situation.
Cœur
22.9k1010 gold badges130130 silver badges188188 bronze badges
SebSeb
Browse other questions tagged ms-wordconditional-formattingword-2013 or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |