Hi all,

is there a way to force a user to enter a value in a given cell? For
instance, I have data in cells a1 through g1, and in h1 I would like to
force the user to enter a particular value, either "h" or "m" in that cell.
No other value, just h or m, and no blanks allowed. I tried using data
validation, custom, formula equals =or(h1="h",h1="m"), which works partway,
except that it allows the cell to be blank. Any ideas?

TIA,

Jim

I'd use an adjacent cell (I1???):

=if(or(h1="h",h1="m"),"","<-- Invalid--only H or M")

Format in big bold red letters.

Jim wrote:
>
> Hi all,
>
> is there a way to force a user to enter a value in a given cell? For
> instance, I have data in cells a1 through g1, and in h1 I would like to
> force the user to enter a particular value, either "h" or "m" in that cell.
> No other value, just h or m, and no blanks allowed. I tried using data
> validation, custom, formula equals =or(h1="h",h1="m"), which works partway,
> except that it allows the cell to be blank. Any ideas?
>
> TIA,
>
> Jim

--

Dave Peterson

Thanks, dave....that does the trick nicely.

Jim

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:4872C970.7C6C5DBC@verizonXSPAM.net...
> I'd use an adjacent cell (I1???):
>
> =if(or(h1="h",h1="m"),"","<-- Invalid--only H or M")
>
> Format in big bold red letters.
>
> Jim wrote:
>>
>> Hi all,
>>
>> is there a way to force a user to enter a value in a given cell? For
>> instance, I have data in cells a1 through g1, and in h1 I would like to
>> force the user to enter a particular value, either "h" or "m" in that
>> cell.
>> No other value, just h or m, and no blanks allowed. I tried using data
>> validation, custom, formula equals =or(h1="h",h1="m"), which works
>> partway,
>> except that it allows the cell to be blank. Any ideas?
>>
>> TIA,
>>
>> Jim
>
> --
>
> Dave Peterson