Change font color based on changes made on specific worksheets

[Miss_Mel]

Hey guys, I need help figuring this thing out..

I have a workbook with multiple worksheets - let's say Sheet A, B, C, and D.

Sheet A = Used as a draft copy
Sheet B = Attributed to team "B"
Sheet C = Attributed to team "C"
Sheet D = Used as a final/reviewed copy

First, data is entered on Sheet A. Then, each team is asked to review and make changes - if required - to their own worksheet (B or C). Sheet D reflects the changes made by each team on their own sheets using vlookup.

I added the Worksheet_Change event under worksheet B and C and used the coding Target.Font.Color = vbRed to change the font color to red whenever a cell value changes. This is working great but, I also want the font color of these cells to change to red on Sheet D.

So far, I tried adding my code under Sheet D, Worksheet_Calculate event but the font is changing to red when data is entered on Sheet A. I need it to change to red only when changes are made to sheet B or C.

Any tips on how to fix this?
Thanks!

 

[Eric W]

Welcome to the MrExcel forum!

Add this line in your existing Change events (on both B and C sheets):

Sheets("Sheet D").Range(Target.Address).Font.Color = vbRed

 

[Miss_Mel]

Welcome to the MrExcel forum!

Add this line in your existing Change events (on both B and C sheets):

Sheets("Sheet D").Range(Target.Address).Font.Color = vbRed

That works beautifully! Super helpfull!
Thanks Eric!

 

[Eric W]

Happy to help! Thanks for the feedback. ?