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?



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. . .

  • Thank you, surfasb - I considered this but was hoping that I would be able to do it directly via Word without embedding an Excel spreadsheet. However, it does appear that this is the only (simplest) way to go about it. Thank you anyway for your very amusing response! – SnookerFan Nov 9 '11 at 10:03
  • Yeah, I must of spent like two hours on researching a different method to test some software yesterday. Instead I could of just finished those tests in those two hours. For me, that was a huge failure in cost/benefit analysis. – surfasb Nov 9 '11 at 17:47
  • I must have missed there was a 96 version of Microsoft office between the 95 and the 97 versions. – R. Schreurs Mar 15 '18 at 9:46

Conditional Formatting in Microsoft Word 2010:

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! :)

  • On Word for Mac go to Advanced Find and Replace > Replace > click the downward pointing chevron in the bottom left to expand > Click in the Replace with field > Click Format popup at the bottom > select the formatting you want. Super easy! – Simon Woodside May 27 '20 at 20:55
  • This is an answer about how to Find and Replace formatting in Word. "Conditional Formatting" implies the creation of a style or element which automatically changes style in reaction to another value or object - such as a user entering text into a Content Control. For that reason I don't find this particularly relevant to the question being asked. – 4AM Oct 29 '20 at 13:49

If you are using merge fields, you can do something like this:

{ IF { =Sum(above) } <> 100 { = Sum(above) \*Charformat } { = Sum(above) \*Charformat } }

And format each field {} with the color you want.

  • This is interesting, but it seems to work only for cells that are computed from other cells. Can you adapt it to work on cells that are simply filled in by a user who edits the document? – Scott May 29 '14 at 17:50
  • I think the only way that could work would be via some macro triggered when you edit the cell. – André May 29 '14 at 21:15

1- Just copy your table from excel 2- In word: Home->Paste options->Link & Keep Source Formatting

  • 1
    That answer is low quality, as it does not explain anything nor show a source. – davidbaumann Nov 14 '18 at 9:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.