Hello,
Say I have a cell where the user enters a temperature value that is used in a formula elsewhere in the sheet. They enter "100". The units, which are set via a user-configurable drop-down box, are currently set to degrees C.
Now let's say the user changes the units setting to degrees F. I want the 100 to automatically change to 212. I do not want it to simply become 100 (F).
How would I go about this? I somehow need to exert control over a non-formula cell
Thanks for any replies.
Say I have a cell where the user enters a temperature value that is used in a formula elsewhere in the sheet. They enter "100". The units, which are set via a user-configurable drop-down box, are currently set to degrees C.
Now let's say the user changes the units setting to degrees F. I want the 100 to automatically change to 212. I do not want it to simply become 100 (F).
How would I go about this? I somehow need to exert control over a non-formula cell
Thanks for any replies.