how to change the color of excel by using equal sign?
which means, if i typed B1 with 1000, and changed color to red
and then in cell A1, i typed =B1, but the strange thing happened, A1 showed 100 but the color did not change to the B1's format (which is color red) and still remain the default color black
how can i make the A1's format equivalent to exactly as B1
dont tell me to change the cell color to red in A1, that is not the answer i want, i want to know, how to just using the equal sign, to get exactly formating from B1
thank you : )
2006-09-20
20:13:55
·
2 answers
·
asked by
stanley w
2