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