Thanks for the mock up. It works well. The formula you added really blows me away!! More complicated then I anticipated. I think I may can make the IIIA part work in Excel through conditional formating. I am just not sure if I can make the rest work,will have to see. I will also try to work on the Word example you have given me.