In Excel, conditional format (font red) referencing another cell?

[Christine Hemphill]

I want to do a conditional format to make cell A1 have red font if cell B1 is
equal to a certain value (text). Can I do a conditional format on a cell
referencing another cell?

[SteveG]

Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve

[Christine Hemphill]

Never mind. Thank you Dave Peterson. Your response to an earlier posting is
exactly what I needed.

"Christine Hemphill" wrote:

> I want to do a conditional format to make cell A1 have red font if cell B1 is
> equal to a certain value (text). Can I do a conditional format on a cell
> referencing another cell?

[Christine Hemphill]

Thank you!!! I just found that answer on another posting. Thank you so much
for your speedy help!!!

"SteveG" wrote:

>
> Christine,
>
> Yes. In A1 go to Conditional Formatting. Change the Cell Value is
> option to Formula is. Enter
>
> =B1="Your Text"
>
> Click Format, Font select the color you want. Click OK, OK.
>
> HTH
>
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=570036
>
>