Conditional formating

K

kosciosco

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

Thanks

Simon
 
B

BigPig

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
 
Top