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.

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.

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

...

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