1) the colours are set with conditional formatting. You will need to edit the conditional formatting rules to change the colours.

For the rest of your questions, your feature wish list reads like a massive project that can only be accomplished with programming, not by adjusting a few formulas.