You can use Data Validation to prevent the entry of an invalid value.

Or you could use event code to delete the invalid value after entry.

Which way to go is up to you.


Gord Dibben MS Excel MVP

On Thu, 11 Feb 2010 07:35:01 -0800, LP wrote:

Hi

In a cell, I want to allow the value only if a condition is satisfied.

If this condition is not satisfied, and if I format the value to be white,
then the value is still in the cell and cannot been seen because it is white.
This is no good. I want no value in the cell.
Any help
Louis