Need help

I have a technical question for a formula or conditional formatting issue. I have the following spreadsheet. I have certain cells which are colour coded. I would like to have the total cells, total o...