Excel macros or anything

So this is the task. There is a look up of different cities Tampa, Pune, Chennai etc. I place people across Jan to Dec and it should calculate the net cost. If total cost is more than allowed total, then turn the cells P2 - P5 red. If less than, turn blue. If equal, turn is: green.