You can link a format from a cell to a picture, but not to another cell. You
can alway transfer the format with a macro, however.
--
Gary''s Student - gsnu200851


"PiL" wrote:

I want to link cells across worksheets so that if I make a change to the cell
format (in this cae, background colour) in cell 1A of sheet 1, the same
change is automatically updated for the same cell in sheet 2. I have access
to both Excel 2003 and 2007.