The format will not carry over.

The easiest way is to use the "Paint Brish" to copy the format and then
paste it to the corresponding cell. To do this, select the cell that contains
the formatting, click on the "Paint Brush" and then go to the consolidadeted
sheet and click on the cell which you want the formatting to be applied.

This should sort it out.

Regards,
Robert

"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.