Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Font color different for part of text/formula (Office 2000)

    Hello,

    I have a title (text in a cell) where I can color the font of just some words in that text, for highlighting purposes.
    I had, however, to create a formula instead of the simple text, something in the lines of:
    ="Availability by Brand Family -" & A8 & " - Premium"
    which takes text from different cells (I have over 300 of these so just typing them 300 times is not an option, when I have names like Dnipropetrovska within my text!!).
    My problem now is that I cannot change the font color to words within the text, as it does not allow me anymore. Is it because the text became a formula? And is there a workaround for it, as I really need to color in red words like 'Premium', etc...

    Thanks!

    K

  2. #2
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Font color different for part of text/formula (Office 2000)

    Kislany,
    While we're waiting for the clever guys, a possible stopgap workaround might be to use conditional formatting to apply a colourful or distnctive formatting to the whole contents of the cells concerned, and/or the cells themselves? Or by hand, if necessary.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Font color different for part of text/formula (Office 2000)

    Another option is to truncate the formula to this much
    ="Availability by Brand Family -" & A8 & " - "
    and put it right-aligned in cell J8, say. Then in K8 copy the word 'Premium' from wherever it is, left aligned, and distinctively coloured to taste.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Font color different for part of text/formula (Office 2000)

    Are the cell contents going to change often? If not, you could replace the formulas by their values; then you would be able to modify the formatting of part of the cell again. If necessary, you could create a macro that applies the formatting.

    To replace formulas by their values:
    1. <LI>Select a range of cells.
      <LI>Copy to the clipboard (Edit/Copy or Ctrl+C).
      <LI>(Keep the range selected.)
      <LI>Edit/Paste Special..., Values option, OK
    This can also be automated by creating a simple macro and assigning it to a toolbar button or keyboard shortcut.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Font color different for part of text/formula (Office 2000)

    <hr>To replace formulas by their values:<hr>

    A simple way:

    - select the cells
    - drag the *border* of the selection with the *right* mousebutton: drag it one cell from it's original location and then (without releasing!) drag it back in place
    - let go of the right button and choose "copy here as values only"
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Font color different for part of text/formula (Office 2000)

    Thanks, Jan Karel.

    Nice trick - hadn't seen that one before.

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Font color different for part of text/formula (Office 2000)

    Hey, that's cute! I hadn't tried dragging borders before.
    Legare Coleman

Posting Permissions

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