Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question
up vote 2 down vote accepted

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

share|improve this answer
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

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

share|improve this answer

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.

share|improve this answer
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .