conditional formatting

[nique012]

Hello,

I need A1 to turn red, when A3 is equal to 125.

I don't want to use Visual Basic though ...

Any suggestions?

Nic

 

[Guest]

select A1 <format><conditional format>
change "cell value is" to "formula is"
formula is: =A3=125
set format patterns to red
note I sometimes have to go back into conditonal formats and get rid of
quote marks where I don't want them(?).

 

[nique012]

Thx,

I tried
=if(a3=125)

but that didn't work of course

Now it works.

thx !