View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt
 
Posts: n/a
Default Highlighting Only Cells with the letter "B"

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" 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