Thanks, BUT I don't think conditional formating will let me do this. It will
let me format THAT cell based upon the condition, but I need it to format
another cell. For example, one cell has a name. The other cell has a
number. I want to set it up so that if the number cell is greater than 20
that the NAME cell has the font/background turn red. Thanks!

"tjtjjtjt" wrote:

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