Conditional formatting

  • Thread starter Thread starter LP
  • Start date Start date
L

LP

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
 
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
 
Back
Top