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

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

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

Copy sheet1a1 and then PasteSpecial format into sheet2
--
Gary's Student


"Mosqui" wrote:

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

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

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.
Mosqui Wrote:
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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=574068

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

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?


"starguy" wrote:


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.
Mosqui Wrote:
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


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=574068