Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

Thanks.

share|improve this question
add comment

3 Answers

up vote 1 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
add comment

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
add comment

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 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 at 21:15
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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