Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2004

Tip: Looking for answers? Try searching our database.

how may I copy color of a other cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Thierry - 30 Sep 2004 22:56 GMT
Hello,
I  need a function that copy also the full format/color/size of a cell
Example
A1 = USD 12'500.00 (monetary size, 12 fat, blue bottom)
A2 = mon 12.03.2004 (dates, 10 not fat, white bottom)
If in A3 I type: =" A1 " I would like a blue bottom, 12 fat, etc. and
If I type =" A2 " a white bottom, 10 not fat, etc....
Is it possible?
Thank you for any help.
Earl Kiosterud - 30 Sep 2004 23:17 GMT
Thierry,

Maybe you can use the Format Painter.  Select the cell that has the
formatting you wish to copy, and click the Format Painter.  It's a
paintbrush on a button on the Standard toolbar.  Now click the cell that's
to be formatted, and the formatting is copied.  If you double-click the
painter, you can click many cells, applying formatting.  Then turn it back
off by either clicking it again, or pressing Esc.

Signature

Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

> Hello,
> I  need a function that copy also the full format/color/size of a cell
[quoted text clipped - 5 lines]
> Is it possible?
> Thank you for any help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.