So, in cell
A1, the user may enter "KG" or "LBS" (data validated).
A2, the user enters a number.
And in cell
A3 a calculation is done and displayed using a formula.
I know I can use a custom number format of 0 "KG" to display KG as text next to the number, and 0 "LBS" to display LBS.
Is it possible to have some conditional number format to display "LBS" or "KG" in
A2 based on the value in
I can't use a formula in that cell because the user needs to enter the required data in that cell. In essence, if conditional formatting had a number format section, I could do this pretty simply. I'm on a Mac, so maybe Excel on Windows has this option?
I assume this can be done easily in VBA, but I'm wondering if this can be done without VBA, and how if so.