I'd suggest you set the data input sheet as a Table. Then formulae, formatting, conditional formatting and data validation will be automatically set up for each new row. You need Conditional Formatting to format cells based on the content of other cells.


Regards, TMS