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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting and VBA 4
Conditional Formatting with VBA 4
Conditional Formatting 1
Conditional Formatting 4
How do I exclude a cell from a range? 4
Excel conditional formatting with Weeknum 4
Conditional format if difference in cell values greater than 0.50% 1
Excel Macro to automatically go to the right of the last colored cell 0

Back
Top