conditional formatting Do anyone have a work around for this p
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
|