| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Is there any way to conditionally block data entry to a cell (lock it)
until data is entered in other cells. Once data has been entered into the pre-quailifying cells I want to open up the locked cell to allow data entry. Thanks GMc |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
You can use data validation but it has limitations.
Assume you don't want to allow an entry in cell B1 until there is an entry in cell A1. Select cell B1 Goto the menu DataValidation Allow: Custom Formula: =COUNTA(A1) OK Limitations: It's possible to copy/paste into cell B1 It's possible to drag-n-drop into cell B1 If there's an entry in cell A1 then cell B1 will accept an entry. However, if the entry is deleted in cell A1 the entry remains in cell B1. -- Biff Microsoft Excel MVP "GMc" wrote in message ... Is there any way to conditionally block data entry to a cell (lock it) until data is entered in other cells. Once data has been entered into the pre-quailifying cells I want to open up the locked cell to allow data entry. Thanks GMc |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
On May 23, 3:40*pm, "T. Valko" wrote:
You can use data validation but it has limitations. Assume you don't want to allow an entry in cell B1 until there is an entry in cell A1. Select cell B1 Goto the menu DataValidation Allow: Custom Formula: =COUNTA(A1) OK Limitations: It's possible to copy/paste into cell B1 It's possible to drag-n-drop into cell B1 If there's an entry in cell A1 then cell B1 will accept an entry. However, if the entry is deleted in cell A1 the entry remains in cell B1. -- Biff Microsoft Excel MVP "GMc" wrote in message ... Is there any way to conditionally block data entry to a cell (lock it) until data is entered in other cells. Once data has been entered into the pre-quailifying cells I want to open up the locked cell to allow data entry. Thanks GMc- Hide quoted text - - Show quoted text - Biff et al., The cell I wish to "lock" already has a data validation parameter (forcing an input of a date between a range of dates). Is there any way to have 2 validations on the same cell ? Thanks Grant |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
You might be able to consolidate both conditions in a single formula.
=AND(COUNTA(A1),B1=DATE(2008,1,1),B1<=DATE(2008,1 ,31)) -- Biff Microsoft Excel MVP "GMc" wrote in message ... On May 23, 3:40 pm, "T. Valko" wrote: You can use data validation but it has limitations. Assume you don't want to allow an entry in cell B1 until there is an entry in cell A1. Select cell B1 Goto the menu DataValidation Allow: Custom Formula: =COUNTA(A1) OK Limitations: It's possible to copy/paste into cell B1 It's possible to drag-n-drop into cell B1 If there's an entry in cell A1 then cell B1 will accept an entry. However, if the entry is deleted in cell A1 the entry remains in cell B1. -- Biff Microsoft Excel MVP "GMc" wrote in message ... Is there any way to conditionally block data entry to a cell (lock it) until data is entered in other cells. Once data has been entered into the pre-quailifying cells I want to open up the locked cell to allow data entry. Thanks GMc- Hide quoted text - - Show quoted text - Biff et al., The cell I wish to "lock" already has a data validation parameter (forcing an input of a date between a range of dates). Is there any way to have 2 validations on the same cell ? Thanks Grant |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
On May 28, 10:45*pm, "T. Valko" wrote:
You might be able to consolidate both conditions in a single formula. =AND(COUNTA(A1),B1=DATE(2008,1,1),B1<=DATE(2008,1 ,31)) -- Biff Microsoft Excel MVP "GMc" wrote in message ... On May 23, 3:40 pm, "T. Valko" wrote: You can use data validation but it has limitations. Assume you don't want to allow an entry in cell B1 until there is an entry in cell A1. Select cell B1 Goto the menu DataValidation Allow: Custom Formula: =COUNTA(A1) OK Limitations: It's possible to copy/paste into cell B1 It's possible to drag-n-drop into cell B1 If there's an entry in cell A1 then cell B1 will accept an entry. However, if the entry is deleted in cell A1 the entry remains in cell B1. -- Biff Microsoft Excel MVP "GMc" wrote in message ... Is there any way to conditionally block data entry to a cell (lock it) until data is entered in other cells. Once data has been entered into the pre-quailifying cells I want to open up the locked cell to allow data entry. Thanks GMc- Hide quoted text - - Show quoted text - Biff et al., The cell I wish to "lock" already has a data validation parameter (forcing an input of a date between a range of dates). Is there any way to have 2 validations on the same cell ? Thanks Grant- Hide quoted text - - Show quoted text - Biff, Thanks again, the AND function works for me. much appreciated. Grant |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "GMc" wrote in message ... On May 28, 10:45 pm, "T. Valko" wrote: You might be able to consolidate both conditions in a single formula. =AND(COUNTA(A1),B1=DATE(2008,1,1),B1<=DATE(2008,1 ,31)) -- Biff Microsoft Excel MVP "GMc" wrote in message ... On May 23, 3:40 pm, "T. Valko" wrote: You can use data validation but it has limitations. Assume you don't want to allow an entry in cell B1 until there is an entry in cell A1. Select cell B1 Goto the menu DataValidation Allow: Custom Formula: =COUNTA(A1) OK Limitations: It's possible to copy/paste into cell B1 It's possible to drag-n-drop into cell B1 If there's an entry in cell A1 then cell B1 will accept an entry. However, if the entry is deleted in cell A1 the entry remains in cell B1. -- Biff Microsoft Excel MVP "GMc" wrote in message ... Is there any way to conditionally block data entry to a cell (lock it) until data is entered in other cells. Once data has been entered into the pre-quailifying cells I want to open up the locked cell to allow data entry. Thanks GMc- Hide quoted text - - Show quoted text - Biff et al., The cell I wish to "lock" already has a data validation parameter (forcing an input of a date between a range of dates). Is there any way to have 2 validations on the same cell ? Thanks Grant- Hide quoted text - - Show quoted text - Biff, Thanks again, the AND function works for me. much appreciated. Grant |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
![GMc[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
