Hi All,
I have on one work sheet traffic lights (from a drop down list you can choose either green, amber or red) - when you do the background for that cell becomes red, green or amber.
How can I reference this cell from another worksheet, and have the color change on the new worksheet - I have tried just linking it over but it doesnt work.
If the cell I want to reference is (a4) in worksheet Projects.
Any help
Thank you
Tim
I have on one work sheet traffic lights (from a drop down list you can choose either green, amber or red) - when you do the background for that cell becomes red, green or amber.
How can I reference this cell from another worksheet, and have the color change on the new worksheet - I have tried just linking it over but it doesnt work.
If the cell I want to reference is (a4) in worksheet Projects.
Any help
Thank you
Tim