conditional formatting

[Guest]

Hi,

how can I have a cell highlighted (light gray) if the cell contains the
letters Vol

ex: if a cell contains> Vol 5 Chapter 3 xyz protocol

In this case I would like the cell to then automatically be highlighted
because it contains "Vol"

Thank You,
BD

 

[Dave Peterson]

You could use format|conditional formatting

And use a formula like:
=COUNTIF(A1,"*vol*")
or
=ISNUMBER(SEARCH("vol",A1))

If you want it to be case sensitive, use Find (instead of search) and make sure
you capitalize VOL the way you want.

 

[Guest]

Thank you very much.
BD

You could use format|conditional formatting

And use a formula like:
=COUNTIF(A1,"*vol*")
or
=ISNUMBER(SEARCH("vol",A1))

If you want it to be case sensitive, use Find (instead of search) and make sure
you capitalize VOL the way you want.