VBA: 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!

scenario 1.JPG

scenario 2.JPG

scenario 3.JPG

[AliGW]

Welcome to the forum.

This cannot be done natively. Would you like me to move this to the VBA section for you?

[RMLAX]

Yes please. Thanks for the heads up.

[AliGW]

Thread moved and title tagged.

[RMLAX]

Found help via another forum.

Here's what I came up with and works for my purposes:

I was able to reformat the parent cell and run the macro to update the sheet everytime I needed a new format.

My line ended up looking like this:

Please Login or Register  to view this content.

Anytime you change the formatting of the parent cell (e.g. add, remove decimal places) you have to run the macros to update.

Hope this helps someone else and thanks!