Set a cell's decimal places by the value of another cell

[daheefman]

Here is my workbook

On the Calibration sheet I have a Data Validation drop down menu which allows me to select from Description on the List sheet Table. Each entry has a DP value that they report to.Users can select a balance and start entering weights in the Weight 1 - 10 Rows, but I need the number of DP used in those cells to match the number of DPs the balance reports in.


It would be easy with cell formula but I can't see how this will help because the cells I want to have this formatting are the same cells I want users to enter data into.


Because I want more balances to be able to be added to the table in the future I don't think conditional formatting will help either because AFAIK one rule would be needed for each balance...


Any solutions? Thanks for the help guys!

 

[pgc01]

Because I want more balances to be able to be added to the table in the future I don't think conditional formatting will help either because AFAIK one rule would be needed for each balance...

Hi
Welcome to the board

No, you could build a table with all the balances and respective DP's and use 1 rule for each DP Value.

For ex.:

[TABLE="width: 128"]
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"]balance[/TD]
[TD="class: xl63, width: 64"]DP
[/TD]
[/TR]
[TR]
[TD="class: xl63"]balance1[/TD]
[TD="class: xl63, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl63"]balance2[/TD]
[TD="class: xl63, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl63"]balance3[/TD]
[TD="class: xl63, align: right"]2
[/TD]
[/TR]
[TR]
[TD="class: xl63"]balance4[/TD]
[TD="class: xl63, align: right"]1
[/TD]
[/TR]
[TR]
[TD="class: xl63"]balance5[/TD]
[TD="class: xl63, align: right"]3
[/TD]
[/TR]
[TR]
[TD="class: xl63"]balance6[/TD]
[TD="class: xl63, align: right"]3
[/TD]
[/TR]
</tbody>[/TABLE]

Then the conditional formatting rules would look for the balance in the table and set the DP.

Does this help?