Shading Select Table with VBA

I have a document previously generated by a mail merge. Each page is identical other than the data filled in by the mail merge.

I would like a VBA routine that reads the table on the top right of each page to determine the color based on the text in that table. Either Green, Blue, Yellow or White. Once the color is determined, fill in that table with the color plus the three tables on that page that describe the student's name and their car. If the color is White, then do nothing on that page. Pages 1 and 3 have the results I am trying to accomplish.

I have some VBA experience with Excel but I have never written any VBA for WORD. Any help would be appreciated.

Assuming the structure is consistent then the following should do it. You will need to remove the existing highlight color if you change the color constants ... i've deliberately used the same ones for blue and green. But included a comment in each case for a potential word constant to make re-use easier ... simply delete the cb constant and the tick to leave the word color constant.

There is a feature provided by MS Word that lets you create an Table of Contents for your Word document automatically.
To use this feature for other documents there are two steps involved,
1. Prepare your document for a table of contents (he…

A few years ago I was very much a beginner at VBA, and that very much remains the case today. I'll do my best to explain things as I go in the hope that other beginners can follow. If you just want to check out a tool that creates a Select Case fu…