Hello,

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

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

Any suggestions?

Nick


--
nique012
------------------------------------------------------------------------
nique012's Profile: http://www.excelforum.com/member.php...o&userid=27653
View this thread: http://www.excelforum.com/showthread...hreadid=471708

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" wrote:


Hello,

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

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

Any suggestions?

Nick


--
nique012
------------------------------------------------------------------------
nique012's Profile: http://www.excelforum.com/member.php...o&userid=27653
View this thread: http://www.excelforum.com/showthread...hreadid=471708

Thx,

I tried
=if(a3=125)

but that didn't work of course

Now it works.

thx !


--
nique012
------------------------------------------------------------------------
nique012's Profile: http://www.excelforum.com/member.php...o&userid=27653
View this thread: http://www.excelforum.com/showthread...hreadid=471708