Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Formulas
Hi,
I am using data validation formulas under the "custom" drop-down" heading to control the allowed input into a given cell. However, I also wanted to include in the expression a constraint that would not allow an entry until the previous cell had been filled as well. It seems that when I add "NOT(ISBLANK(B3))", "ISTEXT(B3))" or any other entry to my formula controlling C3, i.e. "=AND(ISTEXT(B3),C3=DATE(2008,1,1),C3<=DATE(2012, 12,31))", the formula stops activating the Error Alert and allows me to enter anything I want. Any thoughts on why the formula would stop performing once I reference a cell other than the one I am making an entry in? Thanks in advance for the help, Brian |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Formulas
=AND(ISTEXT(B3),C3=DATE(2008,1,1),C3<=DATE(2012, 12,31))
Uncheck the "ignore blank" check box -- Biff Microsoft Excel MVP "leimst" wrote in message ... Hi, I am using data validation formulas under the "custom" drop-down" heading to control the allowed input into a given cell. However, I also wanted to include in the expression a constraint that would not allow an entry until the previous cell had been filled as well. It seems that when I add "NOT(ISBLANK(B3))", "ISTEXT(B3))" or any other entry to my formula controlling C3, i.e. "=AND(ISTEXT(B3),C3=DATE(2008,1,1),C3<=DATE(2012, 12,31))", the formula stops activating the Error Alert and allows me to enter anything I want. Any thoughts on why the formula would stop performing once I reference a cell other than the one I am making an entry in? Thanks in advance for the help, Brian |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Formulas
Thank you so much for the help! That seemed to have done the trick. Been
working with this off and on for days and couldn't get it to work! Thanks again! Brian "T. Valko" wrote in message ... =AND(ISTEXT(B3),C3=DATE(2008,1,1),C3<=DATE(2012, 12,31)) Uncheck the "ignore blank" check box -- Biff Microsoft Excel MVP "leimst" wrote in message ... Hi, I am using data validation formulas under the "custom" drop-down" heading to control the allowed input into a given cell. However, I also wanted to include in the expression a constraint that would not allow an entry until the previous cell had been filled as well. It seems that when I add "NOT(ISBLANK(B3))", "ISTEXT(B3))" or any other entry to my formula controlling C3, i.e. "=AND(ISTEXT(B3),C3=DATE(2008,1,1),C3<=DATE(2012, 12,31))", the formula stops activating the Error Alert and allows me to enter anything I want. Any thoughts on why the formula would stop performing once I reference a cell other than the one I am making an entry in? Thanks in advance for the help, Brian |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Formulas
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "leimst" wrote in message ... Thank you so much for the help! That seemed to have done the trick. Been working with this off and on for days and couldn't get it to work! Thanks again! Brian "T. Valko" wrote in message ... =AND(ISTEXT(B3),C3=DATE(2008,1,1),C3<=DATE(2012, 12,31)) Uncheck the "ignore blank" check box -- Biff Microsoft Excel MVP "leimst" wrote in message ... Hi, I am using data validation formulas under the "custom" drop-down" heading to control the allowed input into a given cell. However, I also wanted to include in the expression a constraint that would not allow an entry until the previous cell had been filled as well. It seems that when I add "NOT(ISBLANK(B3))", "ISTEXT(B3))" or any other entry to my formula controlling C3, i.e. "=AND(ISTEXT(B3),C3=DATE(2008,1,1),C3<=DATE(2012, 12,31))", the formula stops activating the Error Alert and allows me to enter anything I want. Any thoughts on why the formula would stop performing once I reference a cell other than the one I am making an entry in? Thanks in advance for the help, Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation formulas | Excel Discussion (Misc queries) | |||
formulas/data validation | Excel Worksheet Functions | |||
Data Validation formulas | Excel Discussion (Misc queries) | |||
formulas for data validation | Excel Discussion (Misc queries) | |||
Data Validation using whole numbers from formulas | Excel Discussion (Misc queries) |