conditional formatting
 

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?

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, formatconditional formatting. formula is =A10
choose green color. OK.

"Nathan1111" wrote in message
...
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?