software

Hi Guys

How do i select/highlight Only Cells with the letter quot;Bquot; so eventually
delete them

Merry Xmas

Thanks

Andrew--
koba
------------------------------------------------------------------------
koba's Profile: www.excelforum.com/member.php...oamp;userid=28639
View this thread: www.excelforum.com/showthread...hreadid=494481If you are looking for cells that contain quot;Bquot; only, you could do it two
ways.

1) Use AutoFilter and filter for quot;Bquot; in the column of interest
2) Use conditional formatting to highlight the cells that have quot;Bquot; in them.
Select the cells you want to check, FORMAT -gt; Conditional Formatting -gt; Cell
value equals B

quot;kobaquot; gt; wrote in message
...
gt;
gt; Hi Guys
gt;
gt; How do i select/highlight Only Cells with the letter quot;Bquot; so eventually
gt; delete them
gt;
gt; Merry Xmas
gt;
gt; Thanks
gt;
gt; Andrew
gt;
gt;
gt; --
gt; koba
gt; ------------------------------------------------------------------------
gt; koba's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28639
gt; View this thread: www.excelforum.com/showthread...hreadid=494481
gt;

thanks!!!!!--
koba
------------------------------------------------------------------------
koba's Profile: www.excelforum.com/member.php...oamp;userid=28639
View this thread: www.excelforum.com/showthread...hreadid=494481If you need any cell that contains quot;Bquot; or quot;bquot; as part of a text string, you
could use conditional formatting, set for 'Formula Isquot;
=NOT(ISERROR(SEARCH(quot;bquot;,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.

Stevequot;kobaquot; gt; wrote in message
...
gt;
gt; Hi Guys
gt;
gt; How do i select/highlight Only Cells with the letter quot;Bquot; so eventually
gt; delete them
gt;
gt; Merry Xmas
gt;
gt; Thanks
gt;
gt; Andrew
gt;
gt;
gt; --
gt; koba
gt; ------------------------------------------------------------------------
gt; koba's Profile:
gt; www.excelforum.com/member.php...oamp;userid=28639
gt; View this thread: www.excelforum.com/showthread...hreadid=494481
gt;