linking cells

J

Jacqueline

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!
 
D

Dave Peterson

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????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top