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

[Kislany]

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

[itshimagain]

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.

[itshimagain]

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.

[HansV]

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.

[pieterse]

<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"

[HansV]

Thanks, Jan Karel.

Nice trick - hadn't seen that one before.

[LegareColeman]

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