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.