Text colour for certain words ?

  • Thread starter Thread starter Andy100
  • Start date Start date
A

Andy100

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
 
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
 
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
 
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)
 
Back
Top