Does anyone know a work around for this
I am trying to find a way to color background of a cell in Access if it
simply containes the letter "D".
the cell may contain other letters other than the letter D, but will not
matter. I am looking for how to have a background of red if the cell
containes the letter "D", ingore all other letters.
Conditional formatting in Excell 2003 does not have a choice for "CONTAINES"
Thank you in advance for your help

Hi,

I assume you want this in Excel. Select your cell then
Format|Conditional format
Select Formula is
Enter the formula
=NOT(ISERROR(SEARCH("D",A1)))
Pick your colour
OK

Mike

"Shaddow Jake" wrote:

> Does anyone know a work around for this
> I am trying to find a way to color background of a cell in Access if it
> simply containes the letter "D".
> the cell may contain other letters other than the letter D, but will not
> matter. I am looking for how to have a background of red if the cell
> containes the letter "D", ingore all other letters.
> Conditional formatting in Excell 2003 does not have a choice for "CONTAINES"
> Thank you in advance for your help
>
>

On Fri, 7 Nov 2008 05:05:02 -0800, Shaddow Jake <Shaddow
(E-Mail Removed)> wrote:

>Does anyone know a work around for this
>I am trying to find a way to color background of a cell in Access if it
>simply containes the letter "D".
>the cell may contain other letters other than the letter D, but will not
>matter. I am looking for how to have a background of red if the cell
>containes the letter "D", ingore all other letters.
>Conditional formatting in Excell 2003 does not have a choice for "CONTAINES"
>Thank you in advance for your help
>


=ISNUMBER(SEARCH("D",A1))

or, if it should be case-sensitive:

=ISNUMBER(FIND("D",A1))
--ron

Thank You Mike, This worked very well, I did have to change the cell number
from "A1" to the original cell location of "F1". Works great, thank you and
have a nive weekend

"Mike H" wrote:

> Hi,
>
> I assume you want this in Excel. Select your cell then
> Format|Conditional format
> Select Formula is
> Enter the formula
> =NOT(ISERROR(SEARCH("D",A1)))
> Pick your colour
> OK
>
> Mike
>
> "Shaddow Jake" wrote:
>
> > Does anyone know a work around for this
> > I am trying to find a way to color background of a cell in Access if it
> > simply containes the letter "D".
> > the cell may contain other letters other than the letter D, but will not
> > matter. I am looking for how to have a background of red if the cell
> > containes the letter "D", ingore all other letters.
> > Conditional formatting in Excell 2003 does not have a choice for "CONTAINES"
> > Thank you in advance for your help
> >
> >

excuse me for not rating the post. This is my first time here and I am trying
to find out how to rate it with "excelent".

"Mike H" wrote:

> Hi,
>
> I assume you want this in Excel. Select your cell then
> Format|Conditional format
> Select Formula is
> Enter the formula
> =NOT(ISERROR(SEARCH("D",A1)))
> Pick your colour
> OK
>
> Mike
>
> "Shaddow Jake" wrote:
>
> > Does anyone know a work around for this
> > I am trying to find a way to color background of a cell in Access if it
> > simply containes the letter "D".
> > the cell may contain other letters other than the letter D, but will not
> > matter. I am looking for how to have a background of red if the cell
> > containes the letter "D", ingore all other letters.
> > Conditional formatting in Excell 2003 does not have a choice for "CONTAINES"
> > Thank you in advance for your help
> >
> >

I'm glad I could help

"Shaddow Jake" wrote:

> excuse me for not rating the post. This is my first time here and I am trying
> to find out how to rate it with "excelent".
>
> "Mike H" wrote:
>
> > Hi,
> >
> > I assume you want this in Excel. Select your cell then
> > Format|Conditional format
> > Select Formula is
> > Enter the formula
> > =NOT(ISERROR(SEARCH("D",A1)))
> > Pick your colour
> > OK
> >
> > Mike
> >
> > "Shaddow Jake" wrote:
> >
> > > Does anyone know a work around for this
> > > I am trying to find a way to color background of a cell in Access if it
> > > simply containes the letter "D".
> > > the cell may contain other letters other than the letter D, but will not
> > > matter. I am looking for how to have a background of red if the cell
> > > containes the letter "D", ingore all other letters.
> > > Conditional formatting in Excell 2003 does not have a choice for "CONTAINES"
> > > Thank you in advance for your help
> > >
> > >