2003 excel

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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
 
Back
Top