Check active cell value without using macro
 

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

Check active cell value without using macro
 

Tools
Autocorrection

change N to No automatically

--
met vriendelijke groetjes


"simon" schreef in bericht
...
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

Check active cell value without using macro
 

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" wrote in message
...
Tools
Autocorrection

change N to No automatically

--
met vriendelijke groetjes


"simon" schreef in bericht
...
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

Check active cell value without using macro
 

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


"Rick Rothstein" schreef in bericht
...
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" wrote in message
...
Tools
Autocorrection

change N to No automatically

--
met vriendelijke groetjes


"simon" schreef in bericht
...
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

Check active cell value without using macro
 

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

--
Rick (MVP - Excel)


"Frederik" wrote in message
...
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


"Rick Rothstein" schreef in bericht
...
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" wrote in message
...
Tools
Autocorrection

change N to No automatically

--
met vriendelijke groetjes


"simon" schreef in bericht
...
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