I am using Excel 2000. (I should get a later version if for no other
reason than its programming  ability features, but I can't convince
anyone of that.<g>)

I have been working on this the past few hours, and it looks like seven
formats is preferable, which is why I was trying to do it in VBA. Just
can't seem to do the font color correctly, just background  color so far.
I am wondering if Excel 2000 has font color control  in VBA?