How can I get the value and the format of a cell.

M

Mosqui

Say I have sheet 1, cell a1 painted red and value 100. In sheet 2 I want to
have the same value and format.
I do =+sheet1!a1, so I get the value, but how I get the color?

Thanks in advance.

Mosqui
 
S

starguy

formates cannot be fetched by formulas however try following procedure,
I hope you will get what you required.
put following function in sheet2 A1 instead of simple =sheet1!A1
this would fetch values from sheet1 if cell has value otherwise it will
keep the cell blank in sheet2.

=IF(Sheet1!A1="","",Sheet1!A1)

copy this formula across the range in sheet2 to the extent you have
data in sheet1.

then copy the whole sheet1 and come in sheet2 and right click on cell
A1, select Paste Special > Formats > Ok
this will copy formats from sheet1 to sheet2 without disturbing your
formulas and resulting values.

hope this would serve your purpose.
 
M

Mosqui

Thanks for the answer, but is not what I need.
Ii have a summary on sheet 1, which is coming from different sheets. What I
need is that when I fill with colour a cell in sheet 1, the cell where this
value is coming from also gets coloured.
So, I can relate the values from one sheet to the other, but how I do with
the colours?
 
Top