Looking for some method of displaying cell values in 2 different ways.
Is there a way to display cell values (some cell values are hard coded others contain a formula) in two different ways.
e.g. I have a column of Fahrenheit values that I would like to display in Celsius – maybe when the curser move over the Fahrenheit cell (32 F) , the corresponding Celsius value ( 0 C) can be displayed?
Is there a way to dynamically display a calculated value based on the cell value that the cursor is currently over – e.g. If the cell
Bookmarks