Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.vba.general,microsoft.public.word.vba.userforms,microsoft.public.word.vba.beginners,microsoft.public.word.tables
|
|||
|
|||
Tricky: Word Table Conditional Formatting
Hi there,
I've got a stumper..... First, I have a Word document with several form fields. Some of these fields calculate into subsequent bookmarks. The problem: At the end of the Word document, I have a simple "Overall Score" table that is 2x4, laid out as such: Ranking Rating Fair 0-.99 Good 1-1.99 Great 2-2.99 Excellent 3-4.00 The rating is based on the value of a bookmark (GrandTotal) calculated by a macro earlier in the document; the rating can be from 0-4 in half-point increments. So, an average rating would be, for instance, 2.5, which would be a ranking of "Great." What I need to happen is this: Once the "GrandTotal" bookmark calculates (which it does OnExit from a previous form field), I would like the associated row and column in the "Overall Score" table to highlight; so, if the GrandTotal is 2.5, then "Great" and "2-2.99" would become boldface text with a light blue background. I have done this easily and often in Excel with conditional formatting formulas, but I do not know how to embed the Excel table in Word and have the conditional formatting run off of the Word table bookmark "GrandTotal." Is this possible; or, is there a way to do it with VBA in Word? Or, is there some way to 'hide' the Word bookmark value is the embedded Excel, so I can run the conditional formatting in there? Cheers, TomorrowsMan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Word should allow to 'divide' page by 3 or 4, not just 2 | Page Layout | |||
WP merge file to Word | Tables | |||
How can Word display full path of a file in the title bar? | Microsoft Word Help | |||
Word applies direct format on File open | Microsoft Word Help |