i need a bit of help on my sheet

so there is this i worksheet i've been working on for a couples of weeks now and i was wondering if someone could help me.  so the pink/yellow cells are going to be hidden and the orange/blue ar...