Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |