Text colour for certain words ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy100 - 23 Oct 2004 09:00 GMT

I have an Excel database, how can i get excel to mark every instance of a
certain word in red ??

I know there must be a way, but i'm not very excel literate yet !

Cheers
Andrew

Reply to this Message

VENKAT - 23 Oct 2004 09:17 GMT

put a heading(e.g. "name") to the column . highlight the column- cick
data-filter-autofilter. click arrow at right bottom of "name"-in the list
that pops up click the particualr word or string. Now you will get only
those cells which have this particular word or string.
highlight visible cells and mark red using drawing toolbar.
again click data filter autofilter. now the filter is removed and all data
will be visible but the cells with particular word will be marked red

> I have an Excel database, how can i get excel to mark every instance of a
> certain word in red ??
[quoted text clipped - 3 lines]
> Cheers
> Andrew

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Reply to this Message

Frank Kabel - 23 Oct 2004 09:17 GMT

Hi
have a look at 'Format - Conditional Format'

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> I have an Excel database, how can i get excel to mark every instance of a
> certain word in red ??
[quoted text clipped - 3 lines]
> Cheers
> Andrew

Reply to this Message

Andy100 - 24 Oct 2004 00:42 GMT

Thanks everyone. I did have a look at conditional formatting, but it has
it's problems. e.g. if i wanted to highlight every instance of the word
"ford" and the cell had "my car is a ford" entered in it, when i put a
conditional format on that, it doesn't highlight that cell because it looks
at the whole cell and doesn't just see the word "ford" in it.

Hope this makes sense ??

Cheers
Andy

> Hi
> have a look at 'Format - Conditional Format'
[quoted text clipped - 12 lines]
> > Cheers
> > Andrew

Reply to this Message

Dave Peterson - 24 Oct 2004 00:48 GMT

Format the whole cell if Ford is found anywhere in that cell?

You could use a formula like:
=COUNTIF(A1,"*ford*")
or
=SEARCH("ford",A1)

If you care about matching case exactly, use:
=Find("ford",A1)

> Thanks everyone. I did have a look at conditional formatting, but it has
> it's problems. e.g. if i wanted to highlight every instance of the word
[quoted text clipped - 23 lines]
> > > Cheers
> > > Andrew

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message