Hi,

Do it with a Data Validation formula

Lets say your range starts in A1, select the cells and then

Data|Validation - Formula
enter the formula

=OR(A1="C",A1="R")

Mike

"Leanne M (Aussie)" wrote:

I found the following question and helpfull result however I also would like
to not worry about the drop down in the cell. They are very narrow columns
and they just are unnecessary for only two options.

I just want my cells to only accept R or C - I have done this as suggested
below but dont really want the drop down list.

Select the impacted cells
DataData Validation
Allow: List
Source: F,H
Click [OK]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"aetzkin" wrote:

I am trying to format a cell so that it will only accept the characters H or
F and reject all others.
--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)