View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shaddow Jake[_2_] Shaddow Jake[_2_] is offline
external usenet poster
 
Posts: 2
Default 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