Software
What formula should I use to copy the value and format of reference cell.
Example in A1="World" (in blue)
What should I type in C1 to copy the value and color?
thanks.
by cahsolocahsolo Accepted solution
by boxfiddler Accepted solution
by cahsolocahsolo Accepted solution
is there any different due to the version?
unfortunately i'm using 2000 version.
by boxfiddler Accepted solution
particularly between 2000 and 2007, not least of which is the GUI.
I will have to dig out a reference book for Office 2000. It has been quite some time since I used it.
by thumbsup2 Accepted solution
Formulas will copy the contents of a cell and even the =CELL formula itself will return a code to indicate what the formatting is. But, there is no formula that would copy both the contents and the formatting to another cell.
However, a MACRO can be written that will do that for you. The problem is that it may work in 2000 and possibly not work in later versions of the program. It depends on what commands you use IN the macro. A simple macro should work fine. A complicated one may break in later versions. So, you would have to write it anticipating a later update of the software.
by jdclyde Accepted solution
by cahsolocahsolo Accepted solution
guess macro is the only solution here.
thanks everyone
This discussion is closed to new replies.
Sort by Trending