| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting Do anyone have a work around for this p
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for assistance for an unusual conditional formatting probl | Excel Discussion (Misc queries) | |||
| Conditional formatting - why doesn't this work? | Excel Programming | |||
| Will Conditional Formatting work? | Excel Worksheet Functions | |||
| Will Conditional Formatting work? | Excel Worksheet Functions | |||
| Conditional Formatting Work around? | Excel Worksheet Functions | |||
Hybrid Mode
