Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|