conditional formatting

N

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
 
B

bj

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(?).
 
Top