conditional formatting

[Guest]

I have a simple one I think but have a brain fart

I want a2 to return green if cell a1 is greater than 0. the only thing a2
also needs to be editable?

 

[Dave R.]

Conditional formatting will only format the cell, not change or restrict the
value of cell contents (therefore if A2 is not editable, it's not because of
conditional formatting).

highlight A2, format>conditional formatting. formula is =A1>0
choose green color. OK.