How to create use case simulator using google script in google sheet

[Sophia Wilson]

I have a google sheet in the below-mentioned format.

Google Sheet - https://docs.google.com/spreadsheets/d/1KxqaI-GYWur0Knt_bShI0GURucqU_cawu_sCoG_8Xlc/edit?usp=sharing

I want to updated the rows based on the user input in some columns.
If user put input as 1 in column K, we need to copy all the rows belong to that unique 'ID' and append it below it.

For Example, If user put 1 in column K for 'ID_3' we need to copy all the rows of ID_3' and append exactly below it while changing the 'ID_3' to 'ID_3_Append' for the appended rows and Mark Status` should be null for appended rows.


If user put 1 in column M, We need to check that row or rows belong to which ID and check the Dependency 1, Dependency 2 and Dependency 3 column, if we find that matching ID in all these three columns (Dependency 1, Dependency 2 and Dependency 3), highlight that rows with red.


If user update the value in column L from 'Type 1' to 'Type 2' then copy all the columns from 'Pull_list' tab and replace the column B to I in Test_1 tab.