Color a cell based on its value

[TCL28]

Goodafternoon,
Is it possible to color cell B1 red if cell A1 contains a 0 and color B1 green if A1 contains a 1? Thank you.


Tom

 

[NBVC]

Use Format|Conditional Formatting while in B1

Formulais, a1=0 choose your format,

Then, click Add

Formulais, a1=1, choose your format.

 

[Von Pookie]

Use conditional formatting.

Select B1 and go to Format\Conditional Formatting

Enter

Formula Is | =AND(ISBLANK($A$1)=FALSE,$A$1=0)
and click the Format button to set the color to red.

Click the "Add>>" button to add another condition.
Enter:
Formula is | =$A$1=1
and click the format button to set the color to green.

 

[TCL28]

Thank you all