Is it possible to check the value of a cell without using macros? For
example if somebody enters a "N" into a cell I'd like the cell value
to change to "No" automatically. I've investigated conditional
formatting and using standard =IF statements (=IF(H2=N,"No", "") but
get a circular reference error.

Any thoughts?

Thank you
Simon

Tools
Autocorrection

change N to No automatically

--
met vriendelijke groetjes

(E-Mail Removed)
"simon" <(E-Mail Removed)> schreef in bericht
news:94d54204-6598-4dca-aa15-(E-Mail Removed)...
> Is it possible to check the value of a cell without using macros? For
> example if somebody enters a "N" into a cell I'd like the cell value
> to change to "No" automatically. I've investigated conditional
> formatting and using standard =IF statements (=IF(H2=N,"No", "") but
> get a circular reference error.
>
> Any thoughts?
>
> Thank you
> Simon

I think you will need to set it up to change a lower case n to No rather
than the upper case N that you show. Otherwise, typing n into a cell will
just enter the n without converting it; and following that up by typing N in
the cell under it will not change the N to No either.

--
Rick (MVP - Excel)


"Frederik" <(E-Mail Removed)> wrote in message
news:nhqFk.499$%(E-Mail Removed)2...
> Tools
> Autocorrection
>
> change N to No automatically
>
> --
> met vriendelijke groetjes
>
> (E-Mail Removed)
> "simon" <(E-Mail Removed)> schreef in bericht
> news:94d54204-6598-4dca-aa15-(E-Mail Removed)...
>> Is it possible to check the value of a cell without using macros? For
>> example if somebody enters a "N" into a cell I'd like the cell value
>> to change to "No" automatically. I've investigated conditional
>> formatting and using standard =IF statements (=IF(H2=N,"No", "") but
>> get a circular reference error.
>>
>> Any thoughts?
>>
>> Thank you
>> Simon
>
>

If you do

Tools
Autocorrection

Replace n with No

it will work for both the input of n and for N: both will be replaced by No

--
met vriendelijke groetjes

(E-Mail Removed)
"Rick Rothstein" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
>I think you will need to set it up to change a lower case n to No rather
>than the upper case N that you show. Otherwise, typing n into a cell will
>just enter the n without converting it; and following that up by typing N
>in the cell under it will not change the N to No either.
>
> --
> Rick (MVP - Excel)
>
>
> "Frederik" <(E-Mail Removed)> wrote in message
> news:nhqFk.499$%(E-Mail Removed)2...
>> Tools
>> Autocorrection
>>
>> change N to No automatically
>>
>> --
>> met vriendelijke groetjes
>>
>> (E-Mail Removed)
>> "simon" <(E-Mail Removed)> schreef in bericht
>> news:94d54204-6598-4dca-aa15-(E-Mail Removed)...
>>> Is it possible to check the value of a cell without using macros? For
>>> example if somebody enters a "N" into a cell I'd like the cell value
>>> to change to "No" automatically. I've investigated conditional
>>> formatting and using standard =IF statements (=IF(H2=N,"No", "") but
>>> get a circular reference error.
>>>
>>> Any thoughts?
>>>
>>> Thank you
>>> Simon
>>
>>
>

Correct... that is what I was trying to say.

--
Rick (MVP - Excel)


"Frederik" <(E-Mail Removed)> wrote in message
news:BirFk.501$%(E-Mail Removed)2...
> If you do
>
> Tools
> Autocorrection
>
> Replace n with No
>
> it will work for both the input of n and for N: both will be replaced by
> No
>
> --
> met vriendelijke groetjes
>
> (E-Mail Removed)
> "Rick Rothstein" <(E-Mail Removed)> schreef in bericht
> news:(E-Mail Removed)...
>>I think you will need to set it up to change a lower case n to No rather
>>than the upper case N that you show. Otherwise, typing n into a cell will
>>just enter the n without converting it; and following that up by typing N
>>in the cell under it will not change the N to No either.
>>
>> --
>> Rick (MVP - Excel)
>>
>>
>> "Frederik" <(E-Mail Removed)> wrote in message
>> news:nhqFk.499$%(E-Mail Removed)2...
>>> Tools
>>> Autocorrection
>>>
>>> change N to No automatically
>>>
>>> --
>>> met vriendelijke groetjes
>>>
>>> (E-Mail Removed)
>>> "simon" <(E-Mail Removed)> schreef in bericht
>>> news:94d54204-6598-4dca-aa15-(E-Mail Removed)...
>>>> Is it possible to check the value of a cell without using macros? For
>>>> example if somebody enters a "N" into a cell I'd like the cell value
>>>> to change to "No" automatically. I've investigated conditional
>>>> formatting and using standard =IF statements (=IF(H2=N,"No", "") but
>>>> get a circular reference error.
>>>>
>>>> Any thoughts?
>>>>
>>>> Thank you
>>>> Simon
>>>
>>>
>>
>
>