Thank you for the explaination...that helps me understand it a lot more.

Not to throw a monkey wrench in there but, now they need to be able to change the color manually if they want to. if I change the color manually it automatically will change the cell back to the other color.

How do I handle that?

Larry