Hi Guys
How do i select/highlight Only Cells with the letter "B" so eventually delete them
Merry Xmas
Thanks
Andrew
Hi Guys
How do i select/highlight Only Cells with the letter "B" so eventually delete them
Merry Xmas
Thanks
Andrew
If you are looking for cells that contain "B" only, you could do it two
ways.
1) Use AutoFilter and filter for "B" in the column of interest
2) Use conditional formatting to highlight the cells that have "B" in them.
Select the cells you want to check, FORMAT -> Conditional Formatting -> Cell
value equals B
"koba" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
thanks!!!!!
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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks