Check active cell value without using macro

  • Thread starter Thread starter simon
  • Start date Start date
S

simon

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.
 
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
 
Back
Top