Good Morning!

I am not sure if this should be in this forum or Mail Merge, but here it goes:

I have a mail merge letter that contains 7 text boxes. I would like to have the fill color of all 7 text boxes change based on the contents of the last text box; "DAMAGE" = Yellow, "CORE" = Red, "WARRANTY DEFECT" = Green, if it doesn't match any of those 3 then the format doesn't change.



Is this possible, and if can you point me in the right direction.

thanks in advance!

Darren

Cross-posted at: https://answers.microsoft.com/en-us/...1-b6c4b2854e2b
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]