If you need any cell that contains "B" or "b" as part of a text string, you
could use conditional formatting, set for 'Formula Is"
=NOT(ISERROR(SEARCH("b",A1)))
(assuming the range being checked includes A1 as upper left cell)
and then be sure to click the format button and set the desired pattern or
whatever format you want to highlight cells with B.
Steve
"koba" wrote in message
...
Hi Guys
How do i select/highlight Only Cells with the letter "B" so eventually
delete them
Merry Xmas
Thanks
Andrew
--
koba
------------------------------------------------------------------------
koba's Profile:
http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=494481