In a spreadsheet, if cell D5="Barrels", I would like cells A1 to A6 to be formatted to 1 decimal place, but if cell D5="Metric Tons", I would like cells A1 to A6 to be formatted to 3 decimal places.
Cells A1 to A6 have a formula in them and are not blank.
Any simple way of doing this?
Cells A1 to A6 have a formula in them and are not blank.
Any simple way of doing this?