Format text in one cell based on value in another cell

[Guest]

Does anyone know the expression to format text, say in cell A5, to blue if
the value of cell A4>=0 and to red if the value of cell A4<0? I know how to
do conditional formatting on cell A4, based on the value of cell A4, but how
do you format one cell based on the value of another?

Thanks in advance for your help!

Liz

 

[Dave R.]

You're on your way. Just use the "formula is.." option in conditional
formatting of A5 and plug in
=A4<0, choose color, then A4>=0 and choose color.

 

[Guest]

Great! Thanks, Dave!

You're on your way. Just use the "formula is.." option in conditional
formatting of A5 and plug in
=A4<0, choose color, then A4>=0 and choose color.