Conditional Number Formatting

[donkirk]

I have a sheet where a number of cells require data input. Dependin
where in the world the user of the sheet is, and depending on th
preferences of the company the user is working for, there are a numbe
of different units (i.e. "Ft" or "m" for length) that the various dat
numbers represent.

I've created lists of all possible units for each data type and create
dropdown boxes to select the appropriate units.

What I would like to occur is, depending upon the value selected in th
drop-down list box, the data cell will apply a specific Custom Numbe
Format.

For example, the "Total Flow Area" cell has a possible 3 units: in²
mm² or cm². I've created Custom Number Formats for each of these tha
would add the indicated unit to the end of the entered numeric data
seperated by a space (e.g. Custom Number Format: 0" mm²")

For the life of me, I can't figure out how to conditionally apply thes
Custom Number Formats depending on the results from the drop-down bo

 

[Stephen Bullen]

Hi Donkirk,

For example, the "Total Flow Area" cell has a possible 3 units: in²,
mm² or cm². I've created Custom Number Formats for each of these that
would add the indicated unit to the end of the entered numeric data,
seperated by a space (e.g. Custom Number Format: 0" mm²")

For the life of me, I can't figure out how to conditionally apply these
Custom Number Formats depending on the results from the drop-down box

One way would be to display the units in the adjacent cell.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie