"condo" wrote in message
...
I have a summary sheet and I can do the numbers, but how can I bring the
color on cell?
Lets say, I have on sheet3 a cell with number one and color green; on
summary sheet I have a corresponding cell and I want not only th number 1
to
show up, but also the color green. Other numbers are 2 for yellow and 3
for
red. Can i ONLY WRITE THE NUMBER AND GET THE COLOR AUTOMATICALLY ON
SHEET3??
Use Copy followed by Paste special. If you want both number & color, make
sure "All" is selected.
/Fredrik
|