Hello Brad
bjschon wrote:
I have several tables within a word template, all of which have been lableled
with unique bookmarks. I export data from MS Access and autopopulate this
Word template using those bookmarks. The export includes risk data, measured
as High, Mod/High, Moderate, Low/Mod, and Low. Depending on the level of
risk, I would like to change the font color of the data imported into each
bookmark. For example, if the cell within the word table (bookmarked as
IRiskA1) reflects the level of risk "High", I would like "High" to be in red
font.
It would be nice if this conditional formatting was done during
autopopulation, but if it isn't possible, that's okay. A macro in word would
suffice.
"conditional formatting" is not a built-in feature of Word (as it is in
Excel). That basically means that, yes, you will need VBA code for this.
As a GUI person, I would create a character style for each of your risk
levels and apply the correct level on the go.
Since you are already automating Word here, it's not clear where exactly
you need how much assistance. I propose you go into one of the .word.vba
forums and look up past discussions on similar topics. And ask specific
questions there.
HTH
Robert
--
/"\ ASCII Ribbon Campaign | MSFT |
\ / | MVP | Scientific Reports
X Against HTML | for | with Word?
/ \ in e-mail & news | Word |
http://www.masteringword.eu/