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;
- Apr 13 Sun 2008 20:43
Highlighting Only Cells with the letter quot;Bquot;
close
全站熱搜
留言列表
發表留言
留言列表

