# changing cell formats based on other cell content

#### jslomax

##### New Member
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.

John.

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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.

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

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

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

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.

Replies
2
Views
211
Replies
3
Views
117
Replies
1
Views
167
Replies
3
Views
117
Replies
3
Views
292

1,203,531
Messages
6,055,939
Members
444,838
Latest member
Eng76

### 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.

### Which adblocker are you using?

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

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