Format text in one cell based on value in another cell
 

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

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.



"Liz C" wrote in message
...
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

Great! Thanks, Dave!

"Dave R." wrote:

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.



"Liz C" wrote in message
...
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