Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-14-2014, 03:49 PM
chr2014 chr2014 is offline Is there an option to choose font color when replacing text in Excel 2003? Windows XP Is there an option to choose font color when replacing text in Excel 2003? Office XP
Novice
Is there an option to choose font color when replacing text in Excel 2003?
 
Join Date: Nov 2014
Posts: 5
chr2014 is on a distinguished road
Default Is there an option to choose font color when replacing text in Excel 2003?


Hello to all,

Is it possible to replace text with a particular font color in Excel 2003?

I am using an old version of Excel, and it does not give the option of font color choice when replacing text. I was going to purchase Microsoft Office 2003, but wanted to ask first if it would be able to do this.

Thanks,

Chris
Reply With Quote
  #2  
Old 11-14-2014, 06:24 PM
macropod's Avatar
macropod macropod is offline Is there an option to choose font color when replacing text in Excel 2003? Windows 7 64bit Is there an option to choose font color when replacing text in Excel 2003? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,954
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Yes, but the replacement colour applies to the whole cell, not just the replacement text. See Edit|Replace|Replace with>Format|Font.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-14-2014, 06:35 PM
chr2014 chr2014 is offline Is there an option to choose font color when replacing text in Excel 2003? Windows XP Is there an option to choose font color when replacing text in Excel 2003? Office XP
Novice
Is there an option to choose font color when replacing text in Excel 2003?
 
Join Date: Nov 2014
Posts: 5
chr2014 is on a distinguished road
Default

Thank you, Paul.

Are there any versions of Excel that can apply the selected color to only the replacement text, and not the whole cell?
Reply With Quote
  #4  
Old 11-14-2014, 06:38 PM
macropod's Avatar
macropod macropod is offline Is there an option to choose font color when replacing text in Excel 2003? Windows 7 64bit Is there an option to choose font color when replacing text in Excel 2003? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,954
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

AFAIK, no. In all versions, though, it would be possible to do it with a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 11-14-2014, 06:42 PM
chr2014 chr2014 is offline Is there an option to choose font color when replacing text in Excel 2003? Windows XP Is there an option to choose font color when replacing text in Excel 2003? Office XP
Novice
Is there an option to choose font color when replacing text in Excel 2003?
 
Join Date: Nov 2014
Posts: 5
chr2014 is on a distinguished road
Default

What about if I had the text in Word, and in Word I render some words different colors. When I copy the text from Word and paste it into a cell in an Excel 2003 spreadsheet, would Excel 2003 keep the different colors?
Reply With Quote
  #6  
Old 11-14-2014, 07:50 PM
macropod's Avatar
macropod macropod is offline Is there an option to choose font color when replacing text in Excel 2003? Windows 7 64bit Is there an option to choose font color when replacing text in Excel 2003? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,954
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you copy & paste formatted content from Word into Excel, all the text formatting is retained.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 11-14-2014, 07:55 PM
chr2014 chr2014 is offline Is there an option to choose font color when replacing text in Excel 2003? Windows XP Is there an option to choose font color when replacing text in Excel 2003? Office XP
Novice
Is there an option to choose font color when replacing text in Excel 2003?
 
Join Date: Nov 2014
Posts: 5
chr2014 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
If you copy & paste formatted content from Word into Excel, all the text formatting is retained.
When copying and pasting text from a Word document into Excel 97 (the version I have been using) it doesn't retain the formatting. Excel 97 does retain the formatting if copying and pasting from an Excel 97 spreadsheet.
Reply With Quote
  #8  
Old 11-14-2014, 08:41 PM
macropod's Avatar
macropod macropod is offline Is there an option to choose font color when replacing text in Excel 2003? Windows 7 64bit Is there an option to choose font color when replacing text in Excel 2003? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,954
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Are you pasting into the cell, or into the formula bar? You won't get any formatting if you paste into the formula bar.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 11-14-2014, 09:13 PM
chr2014 chr2014 is offline Is there an option to choose font color when replacing text in Excel 2003? Windows XP Is there an option to choose font color when replacing text in Excel 2003? Office XP
Novice
Is there an option to choose font color when replacing text in Excel 2003?
 
Join Date: Nov 2014
Posts: 5
chr2014 is on a distinguished road
Default

I'm pasting into a cell.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there an option to choose font color when replacing text in Excel 2003? Choose color for different number range secoo140 Excel 9 10-07-2013 12:12 PM
how to choose color of a line? fine0023 PowerPoint 1 08-23-2013 02:25 AM
how to search and replace BOLD text >> font color change? dylansmith Word 4 03-12-2013 09:51 PM
text color and font buttons gblackstien Word 0 09-25-2012 05:19 AM
Is there an option to choose font color when replacing text in Excel 2003? New Excel Addin - Office 2003 Color Pallete ioamnesia Excel 1 05-08-2009 10:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft