| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Block cell if specific condition exists
I have 2 cells, A1 and B1. I want to condition B1 so that if A1 contains a
specific value or text, i.e. A1="Filled", then B1 will be blocked and it will not be possible to enter any data into B1. If A1 is any other value except for "Filled", B1 will behave normally and will allow any data entry. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Can I condition format block of cells ? | Excel Discussion (Misc queries) | |||
| Is there a way to color a cell if it meets specific condition | Excel Discussion (Misc queries) | |||
| How to Add columns if a condition exists | Excel Discussion (Misc queries) | |||
| Repeat cell data for specific condition | Excel Discussion (Misc queries) | |||
| How to count occcurence of specific text block in a column | Excel Discussion (Misc queries) | |||
Threaded Mode
