Just to endorse this statement, it will do what you want.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tjtjjtjt" wrote in message
...
Conditional Formatting will let you do this.
Check out the Help Topic Bob mentioned, or look at the website.
Example:
Select cell B6. Go to Format | Conditional Formatting. Then, pick Formula
is
and set the criteris to =B1=50.
Be sure to capitalize the B as the Conditional Formatting box has a nasty
tendency to interpret lowercase letters as text rather than cell
references.

tj

"FORMULA QUESTION" wrote:

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