Conditional formating
 

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: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=528078

Conditional formating
 

HI 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

Conditional formating
 

Much appreciated


--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=528078

Conditional formating
 

Much appreciated


--
kosciosco
------------------------------------------------------------------------
kosciosco's Profile: http://www.excelforum.com/member.php...fo&userid=7068
View this thread: http://www.excelforum.com/showthread...hreadid=528078