software

Is there a way to set formating for a cell which is conditional on the
value in a different cell?

Thanks

Simon--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: www.excelforum.com/member.php...foamp;userid=7068
View this thread: www.excelforum.com/showthread...hreadid=528078HI kosciosco,

Yes. For example, in cell b1, conditional formatting, formula=A1=1, make
whatever format changes ( i used red). Now type in 1 into cell a1.

Hope this helps


Much appreciated--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: www.excelforum.com/member.php...foamp;userid=7068
View this thread: www.excelforum.com/showthread...hreadid=528078
Much appreciated--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: www.excelforum.com/member.php...foamp;userid=7068
View this thread: www.excelforum.com/showthread...hreadid=528078