hello. thx for the response. the drop down cell is D40 .. just two options over or under

h40 is the sum of h39 - h37 which gives a negative number .. therefore since negative when the manager's tab to the next cell to complet d40 they pick over or under. under to be in red.

thx.