What I want to do is enter a percentage complete in one sheet and have a
representative field color coded in the following worksheet that corresponds
to the completed task for that percentage.

Is this possible?