Conditional formatting linked to another cell

M

Montse

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,
 
B

Barb Reinhardt

Selecte the cell you want to format and try something like

Formula Is: =$B$2=1

HTH,
Barb Reinhardt
 
Top