changing cell formats based on other cell content

[jslomax]

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.

 

[jslomax]

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]

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]

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]

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]

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.