ExcelBanter - 2003 excel

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - 2003 excel (https://www.excelbanter.com/new-users-excel/197004-2003-excel.html)

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 ?

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 ?