Results 1 to 12 of 12
  1. #1
    Affiliate Manager Jacqui's Avatar
    Join Date
    April 28th, 2007
    Posts
    248
    How to change color of partial text in a cell?
    Hi,

    I have a list of URLs in a spreadsheet. I'd like to add a code - "[Insert Affiliate ID]" - at the end of each URL. Then I'd like to change the color of this code to red. I can highlight the code to change its color but clicking the next URL for the same edition hyperlinks the URL. Removing the hyperlink turns everything to black. Can someone tell me how to work on this?

    Thank you.

  2. #2
    ...and a Pirate's heart. Convergence's Avatar
    Join Date
    June 24th, 2005
    Posts
    6,918
    What program are you using?...
    Salty kisses, Sandy toes, and a Pirate's heart...

  3. #3
    .
    Join Date
    January 18th, 2005
    Posts
    2,973
    Assuming that you're using Microsoft Excel, I don't think you can do this within the spreadsheet, because Excel always displays hyperlinks in a single style (blue/underlined, though I suppose you could change it to some other fixed style).

    When I select part of a URL and click to set the color, it automatically resets back to the default URL style (blue/underlined).

    What are you trying to accomplish with this? It seems like a very artificial task, and unnecessary (if you're providing the spreadsheet to affiliates, they ought to know to substitute their ID tag for the text you mention).

    If you really need to see parts of the URL in a different color, split the URL into multiple columns, so each column can have its own color, and then have a field that combines the columns into a properly-formatted URL -- but then that URL column won't be a hyperlink within the Excel spreadsheet.

    Or you could extract the desired code from the URL to another column (for example, to display the substring from the "aid=" or "pid=" (or whatever) to the next "&" symbol or end-of-string). Then you can make this column any color you want.

  4. #4
    ABW Ambassador daiarian's Avatar
    Join Date
    April 4th, 2011
    Location
    Beautiful Wales
    Posts
    602
    I have been using Excel for years and I have never come across a cell with two separate colours. When you format that format is for the complete cell and to my best knowledge any value entered in that cell will obey that format in its entirety.

  5. #5
    ...and a Pirate's heart. Convergence's Avatar
    Join Date
    June 24th, 2005
    Posts
    6,918
    Quote Originally Posted by daiarian View Post
    I have been using Excel for years and I have never come across a cell with two separate colours. When you format that format is for the complete cell and to my best knowledge any value entered in that cell will obey that format in its entirety.
    You can change any text within a cell using Excel. We do it all the time...

    Attached Images Attached Images
    Salty kisses, Sandy toes, and a Pirate's heart...

  6. #6
    ...and a Pirate's heart. Convergence's Avatar
    Join Date
    June 24th, 2005
    Posts
    6,918
    Quote Originally Posted by Jacqui View Post
    Hi,

    I have a list of URLs in a spreadsheet. I'd like to add a code - "[Insert Affiliate ID]" - at the end of each URL. Then I'd like to change the color of this code to red. I can highlight the code to change its color but clicking the next URL for the same edition hyperlinks the URL. Removing the hyperlink turns everything to black. Can someone tell me how to work on this?

    Thank you.
    This is for Microsoft Excel 2007 (why I asked what you were using).

    Click the Microsoft Office Button, and then click Excel Options.

    The Excel Options button is located in the lower part of the menu that opens after you click the Microsoft Office Button .
    Click Proofing.
    Click AutoCorrect Options.
    Click the AutoFormat As You Type tab.
    Select or clear the check boxes for the options that you want to enable or disable.
    Salty kisses, Sandy toes, and a Pirate's heart...

  7. #7
    Affiliate Manager Jacqui's Avatar
    Join Date
    April 28th, 2007
    Posts
    248
    If you really need to see parts of the URL in a different color, split the URL into multiple columns, so each column can have its own color, and then have a field that combines the columns into a properly-formatted URL -- but then that URL column won't be a hyperlink within the Excel spreadsheet.
    I'd like to give this a try.

    I have been using Excel for years and I have never come across a cell with two separate colours. When you format that format is for the complete cell and to my best knowledge any value entered in that cell will obey that format in its entirety.
    Exactly what I thought so, too.

    This is for Microsoft Excel 2007 (why I asked what you were using).

    Click the Microsoft Office Button, and then click Excel Options.

    The Excel Options button is located in the lower part of the menu that opens after you click the Microsoft Office Button .
    Click Proofing.
    Click AutoCorrect Options.
    Click the AutoFormat As You Type tab.
    Select or clear the check boxes for the options that you want to enable or disable.
    Convergence, you are a genius!!! Thank you so much. Exactly what I need.

  8. #8
    ...and a Pirate's heart. Convergence's Avatar
    Join Date
    June 24th, 2005
    Posts
    6,918
    Quote Originally Posted by Jacqui View Post
    Convergence, you are a genius!!! Thank you so much. Exactly what I need.
    No genius - info is readily available. However, you are welcome all the same...
    Salty kisses, Sandy toes, and a Pirate's heart...

  9. #9
    Affiliate Manager Jacqui's Avatar
    Join Date
    April 28th, 2007
    Posts
    248
    Convergence,

    Been searching for solutions to my problem and wasn't able to find answers from other forums not even in those that tackle Excel, not until I posted here and you gave me that simple-yet-super answer.

    Thank you. You've just saved me from a lifetime task

  10. #10
    ABW Ambassador daiarian's Avatar
    Join Date
    April 4th, 2011
    Location
    Beautiful Wales
    Posts
    602
    Quote Originally Posted by Convergence View Post
    No genius - info is readily available. However, you are welcome all the same...
    I am using Excel 2003 and cannot see this option available, so with 2007 is it possible to print in two different colours within the same cell?

    Regards

  11. #11
    ...and a Pirate's heart. Convergence's Avatar
    Join Date
    June 24th, 2005
    Posts
    6,918
    Two or two hundred colors, yes...
    Salty kisses, Sandy toes, and a Pirate's heart...

  12. #12
    ABW Ambassador daiarian's Avatar
    Join Date
    April 4th, 2011
    Location
    Beautiful Wales
    Posts
    602
    Quote Originally Posted by Convergence View Post
    Two or two hundred colors, yes...
    Amazing, thanks

  13. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. What Text Color Do You Use For your Site -Text Color Green and Header Light Brown
    By herok in forum Newbie Affiliate FAQs & Helpful Articles
    Replies: 11
    Last Post: June 4th, 2010, 02:31 PM
  2. How do I change the border color on this?
    By bandi in forum Cusimano.com Scripts
    Replies: 1
    Last Post: August 22nd, 2005, 03:05 PM
  3. Change Adsense color
    By Celicaphile in forum Midnight Cafe'
    Replies: 5
    Last Post: August 7th, 2003, 03:22 PM
  4. HTML - color change
    By Javi in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: January 14th, 2003, 02:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •