how do I create an option within a cell to display a different set of values
in a range ? EG MPH/ KPH.
I saw this in a spreadsheet today but could find no formatting etc to reveal
how it was achieved.
It was in the style of an option box,,, click here (spot in a circle) for
set of values 1,,, click here (spot in another circle) for set of values 2
I am using excel 2003