Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting Only Cells with the letter "B"
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting Only Cells with the letter "B"
thanks!!!!! -- koba ------------------------------------------------------------------------ koba's Profile: http://www.excelforum.com/member.php...o&userid=28639 View this thread: http://www.excelforum.com/showthread...hreadid=494481 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting Only Cells with the letter "B"
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I add a single letter to text already in a list of cells? | New Users to Excel | |||
How can I add a two letter prefix to text in cells? | Excel Discussion (Misc queries) | |||
count cells in a coloumn with letter x in it | Excel Worksheet Functions | |||
Count number of cells that contain a certain letter - Case Sensitive | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |