dependent cells to follow decimal formatting of parent cell

[rmlax]

Hello,


New to this forum, I thank you for your help in advance.


I need dependent cells to follow the decimal formatting of a one parent cell. I've done this with format painter but my parent cell decimal requirements changes from time to time and I need the dependent cells to adjust and update accordingly.


Sometimes I might need to show no decimal places while other times I'll need to show one, or possibly two places.


In short, I want to change the decimal formatting of the parent cell and have this dictate the dependent cells on a per case basis.


Please see the following screenshots for examples of what I want to accomplish.


For example only, the Parent cell is in red, dependent cells in yellow. I don't need anything other than the decimal formatting to be copied so color is not an issue.

Thank you!

 

[Fluff]

Hi & welcome to MrExcel.
How about

Sub RMLAX()
   Range("F2").Dependents.NumberFormat = Range("F2").NumberFormat
End Sub

Simply run the macro whenever you change the format of F2

 

[rmlax]

Thanks for this. Where in the code am I calling out the dependent cells, the cells that are to be affected.?

Hi & welcome to MrExcel.
How about

Sub RMLAX()
   Range("F2").Dependents.NumberFormat = Range("F2").NumberFormat
End Sub

Simply run the macro whenever you change the format of F2

 

[Fluff]

With the part in blue

[COLOR=#0000ff]Range("F2").Dependents[/COLOR].NumberFormat = Range("F2").NumberFormat

 

[rmlax]

Great, this worked fine. My line ended up looking like

 Range("D15,F15,H15...[COLOR=#0000ff]")[/COLOR][COLOR=#333333].NumberFormat = Range("F14").NumberFormat[/COLOR]

.

Thanks again!

 

[Fluff]

You're welcome & thanks for the feedback