Thread
:
can I add more than one data validation to a cell
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett