Conditional formatting shapes based on the fill color of another cell

[AndersNOR9]

Hi, I am making a balanced scorecard in excel. I have on sheet called "main", where I have a figure with different goals. To the left of each goal I have a shape which sends me to the sheet where the data for that goal is placed when clicked on. In each sheet with data, the data is filled with either green or red. This is based on whether the number is over or under the goal. I would like to be able to make the shape not only get linked to the cell where the data is located, but also get filled with the same color as the reference cell.

Is this possible?
Best regards, Anders.

 

[AndersNOR9]

Hi,

1. No problem!
2.
If you look at this part: If Sheets("SCM").Cells(9, 6).Value < 0.05 Then
Instead of having Cells(9, 6).Value < 0.05, would it be possible to have it Cells(9, 6).Value < SCM!D9
SCM!D9 is the cell next to F9 and where you can insert the Goal as a percentage. This way you could change the goal in SCM!D9 without having to change the code for the shapes at main to change color correctly. I have used SCM!D9 to conditional format F9, eg F9 is filled with green when F9 is smaller than D9 and red when F9 is greater than D9. My goal would be that the managment could change the goal in D9 without having to go into the VBA code and for example change it from < 0.05 to < 0.03.

3. Thanks, makes completely sense!

Thanks.