Use Conditional Formatting for this. Check out the Help Topic and this website:
http://www.contextures.com/xlCondFormat01.html
tj
"FORMULA QUESTION" wrote:
Is there a way to make the font/background color contingent on another cell?
We think we would use some type of "IF" analysis but ...
For example, if cell B1 = 50 we want cell B6 to be red. Thanks!
Patrick