I'd like to format in bold only cells in a column that contain a B in them. For instance, 5B9776 would be bold and 4C4464P would not be. Any help is much appreciated.
I'd like to format in bold only cells in a column that contain a B in them. For instance, 5B9776 would be bold and 4C4464P would not be. Any help is much appreciated.
Hi use this formula in conditional formatting
=find("B",A1,1)
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Wow. Awesome! Thanks!!
Hi
Try this too:
Regards...Sub makebold()
Dim rcnt As Long
rcnt = Range("A" & Rows.Count).End(xlUp).Row
For i = 1 To rcnt
If InStr(1, Range("A" & i).Value, "B") > 0 Then
Range("A" & i).Font.Bold = True
End If
Next
End Sub
Hi,
You can use custom filter.
Contains *B*
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
Thanks everyone!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks