On 14 Oct 2005 13:06:58 -0700, "
wrote:

Teresa:

The formula that I gave you before to use in the conditional
formatting dialogue works for finding a string of text either solo or
within another string. I use it myself frequently. It will
find"smith" as "Smith","smith" or "Mr Smith" OR "Dave smith ate a
porkchop". Lemme know how things are going... Mark
'

Well, I finally got around to where I could use this, and I guess I
don't get it like I thought I did. I figured out naming a cell, and I
named a "range", since I have 360 cells in A that I'm looking at. I
have 685 values in A on another sheet, and all 360 from sheet 1 are in
this list. The range on sheet 1 is named Criteria, and I chose the
range on sheet 2 and went into Format - Conditional, chose Formula,
made the format a yellow hilite, and pasted in the formula from the
previous post. But none of the cells in sheet 2 lit up.

It worked great if I put the formula in one cell, one of the cells in
Criteria; it sure lit itself up fast. ;-)

The problem here is that I lost the macro I had for just simple text
finding, during the computer crash and all. No clue how that
happened. So I figured I'd put your formula in there, see what I
could do with it. Found out I couldn't do anything with it.

I'm going to do a bit more research on this, it's not like it's a big
deal; I've totally re-worked the inventory so that I don't *have* to
do a search and replace anymore. But it sure would be helpful to
still be able to do this sort of thing.

Thanks for your help!
--
Teresa Robinson