To the best of my knowledge, formatting cannot be included when you create
links - even in the same workbook. Only the cell content/result is supplied
to the linked cell.

If I understand what you are trying to do, the only thing I can suggest is
that you format the appropriate cells in the client workbook the same way as
those linked to in the source. You can use the Format Painter feature
(remember that double-clicking the button leaves it active so you can paste
the formatting to as many different locations as necessary) or you can use
the Paste SpecialFormats command from the edit menu.

If you'll need to set up a number of workbooks the same way, you may also
want to create Styles and/or save a template file set up and formatted as
necessary.

"csfrolich" wrote:

On 500 separate worksheets... I have a conditional format working on a cell
that compares to another cell. If greater that + or minus 4% ...turn red, 6%
turn green and 8% greater turn blue.

Surprisingly I got that to work!

Now I would like to LINK those 500 worksheets to one sheet and retain the
formatting. When I initiated the link.... the formatting does not carry this
over.

Is this at all possible.