Hi,

I would like to enter 1 in a cell and have conditional formatting change that cell to green colour after I enter 1 in that cell.

I would also want the 1 to be deleted after the cell has changed to green.

How can I do this ?

Thanks in advance.