On Sat, 03 Jan 2009 12:41:38 -0600, Dave Peterson
wrote:

It didn't work for me in xl2003.

But I figured I did something wrong.

It always came back that it couldn't find any matches to change.

I used asdfqwerasdf in a bunch of cells with qwer in white and both a&f's
automatic and s&d's in red.

It didn't work for me, either, in 2007. My thought had been that that option,
in both the worksheet and also VBA, is looking at the CELL format, and not at
the format of individual characters within the cell.

That's why I asked the recommender what happened with *his* testing.
--ron