method to copy cell format through formula/VBA?

[ronnielim]

Hi,

Is there a way to copy a cell's format shading/width/height using a
referencing formula or VBA?

Example, I have cells A1:J1 with different background colors, but *no
values*.
I would like copy the cell formats over to another spreadsheet without
-having to put values in those cells-.

-or-

Is there a formula/way that returns the cell background color as a
value?
That way I can get conditional formatting to work.

Reason being, I want to import cell formats from seven different
spreadsheets to one master spreadsheet.

Thanks.
oh btw, I'm using XL2k

 

[Paul Moles]

Try format painter and/or paste special.

Or do you actually want to link the format somehow in a
formula in the combined spreadsheet.

Cheers
Paul