maybe use conditional formatting? i havnt looked at your file, but you can use CF to change color/font etc of cells based on the values in other cells.

play around with it and if you stil have a problem, give us a shout