Conditional Formatting

[Kumara_faith]

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.

[ChemistB]

Conditional formatting will not erase the contents of your cell and if they did, then you would no longer be meeting the conditional formatting and it would revert back to the original.

You could do this with VBA or you could do a workaround by using conditional formatting with the condition Cell Value is equal to 1 and then when formatting, have both the pattern (background) and the font as the same color green so that it appears as if there is nothing in the cell.

Does that work for you or do you need VBA?

ChemistB

[Kumara_faith]

ChemistB,

Thank you for your solution. This will work just fine. Thank you for your time and effort.