Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Help
I am trying to not allow any values to be typed in a row if the last column
in that row has the word "COMPLETED" in it. the word completed is linked to another sheet but it does display the exact word on this sheet with a =cell formula between sheets. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Help
On Mar 20, 11:53 pm, Sean wrote:
I am trying to not allow any values to be typed in a row if the last column in that row has the word "COMPLETED" in it. the word completed is linked to another sheet but it does display the exact word on this sheet with a =cell formula between sheets. Let's say last column is column E. Select range you want to validate and in Data Validation dialog under Costom enter this formula: =IF($E1="COMPLETED";ISBLANK(A1);NOT(ISBLANK(A1))) It will not alow user to enter text or value in cell after "COMPLETED" is in E1, but it still will be posible to delete values or text from cells. -- Regards, Mladen http://excelancije.bloger.hr |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Help
That didn't really work, all I did was change the E1 to my cell with the
completed in it. What was the A1 referring to also. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Help
On Mar 21, 4:31 pm, Sean wrote:
That didn't really work, all I did was change the E1 to my cell with the completed in it. What was the A1 referring to also. Sean, Its important to have dollar sign ($) in reference E1. Instead E1 put upper right cell of your validated range, including column with "COMPLETED" formula. Also, instead A1 you need to put inside uper left cell of your validation range. regards, -- Mladen http://excelancije.bloger.hr |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Loading Column Data with blank Rows into Data Validation Box | Excel Worksheet Functions |