conditional formatting Do anyone have a work around for this probl

[Shaddow Jake]

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

 

[Mike H]

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

 

[Ron Rosenfeld]

On Fri, 7 Nov 2008 05:05:02 -0800, Shaddow Jake <Shaddow

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

 

[Shaddow Jake]

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

 

[Shaddow Jake]

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]

I'm glad I could 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".