I want to make it so that if cell A1 has a negative value in it, say -10, that cells A1 and B1 both have the same fill color (red). I want it to be done automatically as soon as the value is entered into A1. How do I do this. Thanks