Thanks for the responses, this is a user form that is filled in by our customers, then returned to us. I will look into data validation and conditional formatting. AAF Template xxxx.xlsx I have attached it so you can see what i am talking about. I would like the grey cells behind the bag template to turn green/red when approved or not approved. In addition to this i need to make this form un-editable, so all the check boxes/combo boxes cannot be moved. Any additional help on this would be great. thanks.