I am working with one-page document for our stakeholders where I need to activate an option of changing the content of 2nd cell once one of the option of drop-down field in 1st cell is chosen.



For example first cell contains Dropdown options for the question "This equipment is related to safety" - "Yes", "No" and "Partially". Correspondingly I want 2nd cell shows responses "Highest Urgency", "Normal urgency" and "High urgency" with changing font color (or even cell color) from Red for "Highest Urgency" to Green for "Normal urgency" or Yellow.

Or 1st cell contains dropdown questions "This equipment is for export" and "This equipment is for import", and once option chosen in first dropdown field 2nd field shows list of docs for this.

Thanks.