Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I add more than one data validation to a cell
I need to add data validation twice to a cell, but can't figure out
how. Using the data below as an example Record Type Hours Hrs 8 Exp In the Hours column I want to ensure that it can only be populated if the Record Type column contains 'Hrs' and I want to only allow numbers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I add more than one data validation to a cell
try this
custom =and(isnumber(p2),m2="hrs") -- Don Guillett Microsoft MVP Excel SalesAid Software "Ciarán" wrote in message ... I need to add data validation twice to a cell, but can't figure out how. Using the data below as an example Record Type Hours Hrs 8 Exp In the Hours column I want to ensure that it can only be populated if the Record Type column contains 'Hrs' and I want to only allow numbers. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I add more than one data validation to a cell
That worked perfectly.
Thanks Don. On Mar 6, 1:28*pm, "Don Guillett" wrote: try this custom =and(isnumber(p2),m2="hrs") -- Don Guillett Microsoft MVP Excel SalesAid Software "Ciarán" wrote in message ... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I add more than one data validation to a cell
Do you think you could take it one step further and based on Record
Type provided a drop down list? So using Record Type Hours Expense Type Hrs 8 Exp XXXXXXXXX So using a similar data set again, if Record Type = 'Exp', Expesnse Type can be populated with either 'Food', 'Travel' or 'Phone' where I have XXXXXXXXX Regards, Ciarán |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
cell data validation | Excel Discussion (Misc queries) | |||
Validation of data in a cell | Excel Discussion (Misc queries) | |||
Data Validation: Store cell address instead of value in the cell? | Excel Discussion (Misc queries) | |||
Why does data validation not work when pasting data into a cell. | Excel Discussion (Misc queries) |