Is there a way to set up a template to automatically format input cells blue, formulas black, and linked cells green without using a macro and do so as the action of inputting is executed?

I created the templates for my company and a lot of times people will change the template according to the deal. Therefore I need the template to incorporate if the cell is changed to adjust automatically.

Thank you!