I need to make my Google Sheets Spreadsheet automated

Hi,

I need these features added to my Google Sheets spreadsheet:
1) I need the 'CODES USED' section (bottom right) to update every time I add a new code into the F column
2) I need the PROFIT column (K) to be automatically calculated by doing the (revenue - fees - product cost - shipping cost) on its row
3) On the 'WHERE' column (E), I need to make it so that the row (B-L) changes to the correct colour when a word is inputted. E.g. when 'shopify' is inputted it changes to blue, 'amazon' orange, 'etsy' yellow

Please start your message off with 'Sheets' so I know you've understood the job.

The spreadsheet for reference is below (I have just put random data in for now):
https://docs.google.com/spreadsheets/d/1CXZtNS1HSLv_QXhO9O4WXbOaXHL8-BHvVCGpV3H-zx8/edit?usp=sharing

Lucy