Conditional formatting linked to another cell
 

We know that Conditional Formating changes according to the value of the cell
but can I make the format of a cell change according to the value entered in
another cell?

Thank you,

Conditional formatting linked to another cell
 

Selecte the cell you want to format and try something like

Formula Is: =$B$2=1

HTH,
Barb Reinhardt

"Montse" wrote:

We know that Conditional Formating changes according to the value of the cell
but can I make the format of a cell change according to the value entered in
another cell?

Thank you,