Referred cell different format

[harperg11]

Hello,

I am writing a budget workbook and would like a very specific functionality. The workbook has a sheet that is used for a proposed budget when starting to plan our project, then a final budget to complete just before embarking on the project. I would like to have code that will copy or refer cells cells in the proposed budget to the final in a different color that will alert the user that they are copied. Then if a change needs to be made in that cell, the user can type in it and it will automatically reformat to the same format of other cells. For example, the Flight Cost cell would automatically populate in the final budget from the proposed budget cell with light grey writing. Then when the user updates the information in the final budget, the text will turn black. After updating all cells that need to be updated with new numbers, the user would use a button to accept all other referred values and they would their text would then also turn black. I can't find a VBA keyword combination that would make this happen. Any help is appreciated.

[xladept]

Hi Harper,

Welcome to the Forum!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[harperg11]

Thanks for your reply, Orrin.

I have created and attached a sample workbook.
The proposed budget sheet has the original data entered.
The final budget worksheet has cells that reference cells from the proposed worksheet and these should automatically color green.
There are then cells that I updated with new information - these automatically update the format to grey background.
Then I created a shape at the bottom that would be button connected to a macro that would accept any green box number (copied from proposed sheet,
but not updated) and change the background of these cells to grey as well.

The idea is the user will be able to see what numbers were typed in the proposed sheet without having to refer back to that sheet,
update the numbers that have changed since the original budget proposal, then accept all the others as final numbers once the updates are complete.

Thanks for your help with this,
Glenn