I work with a resource management web application. I have a grid of numbers (resources forecasts). I need to show in this grid if the numbers are over or under a reference (resources capacities).
I thought about display the numbers from YELLOW to RED when it's an "over-forecasting" (= conflict). Then I use GREEN when the forecast match the capacity (= everything is perfect).
But I don't know how to display the "under-forecasting" (below the capacity). It's a real business problem too but I need to distinct it from the "over-forecasting". I don't know if a neutral color can do the job (blue ?)
Here is an example of my grid :
If John Smith had a capacity of 5 for june the forecast 12 in the grid will be RED. If Mick Jagger had a capacity of 5 on june too, the forecast 5 will be GREEN. If the capacity is 10, the forecast 5 is BLUE (not convinced with this color...).
Do you have any suggestions in order to improve the UX in this grid and display the under- and over-forecasting ?