Excel Template Programming

Please note that we do not use programming in our templates, only the most basic features of the programs, so the templates become accessible for most users.

Regarding the Risk Treatment template, we use the only "Data validation" feature (accessible through the Data tab) in columns J and K. With this feature you can define warning messages in case wrong data is entered.

For changing the color of a cell you should use the "Conditional Formatting" feature (accessible through the Home tab).

For more information on these features, please see:

• https://support.office.com/en-us/article/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249
• https://support.office.com/en-us/article/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f