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