| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
For a Cell A3, i use '=A2' ..i want to copy the format of A2 also,
Hi,
I have a cell A3 in which i want to insert both the contents and format of the cell A2 .. Can somebody plz advise me on how to go about it.. To be specific, A2 contains a number, say 21 and is shaded blue. Exactly i want the same in A3. (Both the number and color) Sincerely awaiting a reply.. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
For a Cell A3, i use '=A2' ..i want to copy the format of A2 also,
Copy/ Paste (or paste special/ format).
A formula won't pick up the format of another cell. -- David Biddulph "Saravana" wrote in message ... Hi, I have a cell A3 in which i want to insert both the contents and format of the cell A2 .. Can somebody plz advise me on how to go about it.. To be specific, A2 contains a number, say 21 and is shaded blue. Exactly i want the same in A3. (Both the number and color) Sincerely awaiting a reply.. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
For a Cell A3, i use '=A2' ..i want to copy the format of A2 also,
Maybe this will help you
Click in cell A3 and type =A2 this means that what ever is populated in cell A3 will auto maticaly populate in cell A3 Then also you can conditional format the cell to change to certain colours. "Saravana" wrote: Hi, I have a cell A3 in which i want to insert both the contents and format of the cell A2 .. Can somebody plz advise me on how to go about it.. To be specific, A2 contains a number, say 21 and is shaded blue. Exactly i want the same in A3. (Both the number and color) Sincerely awaiting a reply.. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
For a Cell A3, i use '=A2' ..i want to copy the format of A2 a
Hi mates,
Thank You very much for the prompt reply.. I tried conditional formatting but the problem i face is that Cell-A3 must respond to a change in the format of Cell-A2 .. i don't know the formula.. Advise welcome.. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
For a Cell A3, i use '=A2' ..i want to copy the format of A2 a
Not formula, but VBA.
http://www.cpearson.com/excel/colors.aspx, for example -- David Biddulph "Saravana" wrote in message ... Hi mates, Thank You very much for the prompt reply.. I tried conditional formatting but the problem i face is that Cell-A3 must respond to a change in the format of Cell-A2 .. i don't know the formula.. Advise welcome.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| copy the same format to a cell using = | Excel Worksheet Functions | |||
| copy cell format? | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
