I have multiple sheets within a workbook, and all I'm trying to do is link
one cell in a sheet I've named "detailed" to another sheet I've named
"summary". I have a lowercase "l" in wingdings in order to denote a black dot
in the detailed and summary sheets. How do I link the cells so that if
someone changes the dot from red to green in the detailed sheet, it will
automatically change the color of the black dot in the summary sheet? I'm
using this as a form of a dashboard for managing multiple projects. Any help
would be greatly appreciated!

Formulas don't return this kind of formatting.

Maybe you could add another helper cell that's used as an indicator in
format|conditional formatting. The user types an X and the original dot changes
colors.

Then you can retrieve both the dot cell and the indicator cell and do the same
conditional formatting on the receiving sheet????

Jacqueline wrote:

I have multiple sheets within a workbook, and all I'm trying to do is link
one cell in a sheet I've named "detailed" to another sheet I've named
"summary". I have a lowercase "l" in wingdings in order to denote a black dot
in the detailed and summary sheets. How do I link the cells so that if
someone changes the dot from red to green in the detailed sheet, it will
automatically change the color of the black dot in the summary sheet? I'm
using this as a form of a dashboard for managing multiple projects. Any help
would be greatly appreciated!

--

Dave Peterson