| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
2003 excel
I would like to change the cell color if there is a "r" found in it. All the
cells are in the same colum and there are also numbers in the cells with the "r". Can anyone help ? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
2003 excel
Assume data in col A
Select the col, then apply conditional formatting using Formula Is: =ISNUMBER(SEARCH("r",A1)) Format to taste OK out Replace SEARCH with FIND if you need it to be case sensitive -- Max Singapore http://savefile.com/projects/236895 Downloads:16,400 Files:356 Subscribers:53 xdemechanik --- "Dave" wrote: I would like to change the cell color if there is a "r" found in it. All the cells are in the same colum and there are also numbers in the cells with the "r". Can anyone help ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get 2003 Macros and Toolbar Buttons form Excel 2003 to 20 | New Users to Excel | |||
| unable to paste Excel 2003 chart into Outlook 2003 | Charts and Charting in Excel | |||
| import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
| Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
| Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) | |||
Linear Mode
