conditional formatting

[Brian]

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.



Brian wrote:
>
> 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

[Brian]

Thank you very much.
BD

"Dave Peterson" wrote:

> 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.
>
>
>
> Brian wrote:
> >
> > 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
>