Conditional formating-Is there a way to set formating for a cell

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

Thanks

Simon

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

Much appreciated

Much appreciated