choose 3 numbers from an account#

[Smithgall]

i have a list of 10 didgit account numbers. i want to highlight in someway could be as simple as using conditional fomatting to bold the text of all the account numbers that have my assigned range.

Meaning that i am assigned account 150-180. but the way i see if its my account is based on the 7th-9th position.
ex. 9658741671 would be assigned to me because the 167

how do i recognize that part of the number(i guess its actually labled as text) to then use formatting to bold the entire number?

 

[schielrn]

Maybe in conditonal formatting try:

=and((mid(A1,7,3)+0)>=150,(mid(A1,7,3)+0)<=180)

Hope that helps.

 

[jmthompson]

In VBA, try this code. It assumes your account numbers are in column "A" and that there is no header, adjust accordingly.

Sub MyAccounts()
Range("B:B").Insert Shift:=xlToRight
Dim lastRow As Integer
lastRow = Cells(Rows.Count, 1).End(xlUp).Row
With Range("B1:B" & lastRow)
.Formula = "=MID(RC[-1],7,3)"
End With
Range("B:B").Value = Range("B:B").Value

    Dim c As Range
        For Each c In Range([B1], Cells(Rows.Count, "B").End(xlUp))
            If c.Value > 149 And c.Value < 181 Then c.Offset(, -1).Font.Bold = True
        Next c
Range("B:B").Delete
End Sub

 

[Domenic]

Maybe...

=LOOKUP(MID(A1,7,3)+0,{0,150,181},{"N","Y","N"})

Hope this helps!

 

[Smithgall]

thanks for all your help. those worked perfectly.