hilight unique data

[ExcellingAZ]

Hi,

I am looking for a formula or a setting that will take the data from Column "C" and will ID those that do not have the same info in Column "A". So example, C2 has EX_Bill_ this same info also shows in cell A2. But cell C4 has M_Bill and it does not show in cell A4. So A4 I would like to hilight or flag as not matching. Is there a setting or formula that can do this?

 

[C Moore]

Conditional formatting with a new formula will do it. With A2 selected use the following:
=LEFT($A2,LEN($C2))<>$C2
Paste format to other cells.

 

[mumps]

VBA approach:

Sub ColorCells()
    Application.ScreenUpdating = False
    Dim v As Variant, i As Long, x As Long
    v = Range("A2", Range("A" & Rows.Count).End(xlUp)).Resize(, 3).Value
    For i = LBound(v) To UBound(v)
        x = WorksheetFunction.Find("^", WorksheetFunction.Substitute(v(i, 3), "_", "^", 2))
        If Left(v(i, 1), x) <> Left(v(i, 3), x) Then
            Range("A" & i + 1).Interior.ColorIndex = 6
        End If
    Next i
    Application.ScreenUpdating = True
End Sub