If you download Chip Pearson's rowliner add-in you will see that Chip has
provided a way to set the colorfill on part of a cell by layering an object over
part of the cell.

So there is a way by adding a small semi-transparent autoshape over the text in
question.

Exactly where to place it would be the next question.


Gord Dibben MS Excel MVP

On Thu, 11 Oct 2007 19:59:00 -0700, Ean Wilson
wrote:

Okay, I just selected the text within the cell I wanted to highlight. With
that text selected, I moused over to the ribbon and chose the
Home-Cells-Format option. Everything is grayed out except for the very
last option, Format Cells...

I chose that option. The only tab that appears is the Font tab, where I can
format the selected text font attributes. Yes, I can choose a different
color, but I don't want to change my text color. I want to HIGHLIGHT THE
BACKGROUND of that text to a different color.

I just don't see how this is possible. I must be missing something.