changing cell formats based on other cell content

jslomax

New Member
Joined
Nov 20, 2005
Messages
15
Is there a means to change the unit formatting of a cell based on a selection elswhere in the workbook? I would like to be able to change between "ft" and "m" in all cells containing length values based on a single dropdown selection.

Thanks for your help.

John.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

jslomax

New Member
Joined
Nov 20, 2005
Messages
15
amplifying info

I do not need to convert the information as the person entering the data will enter it in either metric or standard units as required by the end customer.

Thanks again.
 

vmottert

Board Regular
Joined
Aug 30, 2003
Messages
215
You can use a conditional formula...

=if(C5=1,formula&"ft",formula&"meters")

where C5 is an user entered value. Hope this helps.

Regards,

Vernon
 

jslomax

New Member
Joined
Nov 20, 2005
Messages
15
Maybe I don't understand what you sent me

Thanks for your input Vernon. I am not certain what you are telling me to do. Are you implying I will need to go to each cell and edit the entires for the calcs? If so that can be done. However, what I am trying to accompish is to have a single entry in the workbook which defines whether or not I am using metric values. If I am measuring length in "meters" then I want all the cells to indicate "m" after the length values I enter and the results of all calculations that give length results. If I am using "feet" then I want to indicate "ft" after all my length values.

Thanks again
John
 

vmottert

Board Regular
Joined
Aug 30, 2003
Messages
215
John,

In my example, if the user entered "1" in cell C5, the conditional formula would use the "True", or first formula. If there was anything other than a "1" in C5, the second formula would be used. Replace "formula" with your formula. The &"ft" or &"m" would append the reuult with the measurement label.

Vernon
 

jslomax

New Member
Joined
Nov 20, 2005
Messages
15
Thanks for your help.

this will work for the cells I have calculations in. Is there a way to alter the formats of cells that I enter data into? Some values I enter are just measurements and the cells don't have a formula attached to them.

Thanks again

John.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,501
Messages
5,832,079
Members
430,110
Latest member
Chyke_mxl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top