Thank you Much James,

The changes you made work great. I knew I had some problems with the syntax. Excel kept telling me the things I was doing wrong. I'm reading a couple of books and trying to get something out of the help files so I can figure these problems out for myself. You guys won't always be around for me to lean on. Seriously, sometimes it helps to see how a task is achieved to be able to put it all together. Thanks for your insights. I'll be glad when I know what is wrong with my syntax instead of just knowing that its wrong! someday. The practice of trying to get these files to do what I want and knowing that I have good people to ask for direction when I get stumped sure makes learning easier.

Parry also has a post here about inserting excel worksheets in Word. It works pretty nicely also. I didn't know about it before but as Parry pointed out, after you insert the worksheet word makes the format-conditional formatting menu available in Word. Pretty handy to know.
Thanks again