Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
How can I get data validation
I want to set up one cell (F41) to contain data validation that verifies that
the entered contents are greater than the contents of another cell (F28). Since F41 needs to be greater than F28, I also want to make sure that F41 can't have input if F28 is blank. The first part of my validation formula works fine by itself but the second part doesn't work. Can I combine these two validation checks in one formula as follows? If not, how should it be set up if it can be done at all? =OR(F41F28,CELL("type",F28)<"b") |
#2
|
|||
|
|||
Hi
=AND((F41F28);F28<"") and uncheck 'Ignore Blank' -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "rrucksdashel" wrote in message ... I want to set up one cell (F41) to contain data validation that verifies that the entered contents are greater than the contents of another cell (F28). Since F41 needs to be greater than F28, I also want to make sure that F41 can't have input if F28 is blank. The first part of my validation formula works fine by itself but the second part doesn't work. Can I combine these two validation checks in one formula as follows? If not, how should it be set up if it can be done at all? =OR(F41F28,CELL("type",F28)<"b") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation screen size | Excel Discussion (Misc queries) | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions |