I have some values on column A such as:

```
"A"        "B"
1           ok
1           ok
1           me
2           next
2           next
2           next

```

My code goes and and color the row on "A" if it is all the same, what i want is if column "A" have all one's to check column "B" for the last value which is "me" if it's there, leave those rows with "1" in column A alone, if it's not, delete all the rows that have "1". Not sure how to accomplish that. any help is appreciated. 

```
Dim i As Long
Dim initialPlaceHolderValue As String
Set UsedRng = ActiveSheet.UsedRange

FirstRow = UsedRng(1).Row
LastRow = UsedRng(UsedRng.Cells.Count).Row
r = WorksheetFunction.RandBetween(180, 255)
g = WorksheetFunction.RandBetween(180, 255)
b = WorksheetFunction.RandBetween(180, 255)
initialPlaceHolderValue = Cells(FirstRow + 1, 1).Value
For i = FirstRow + 1 To LastRow
    myColor = RGB(r, g, b)
    If Cells(i, 1).Value = initialPlaceHolderValue Then
        Debug.Print Cells(i, 19).Value
        Cells(i, 1).EntireRow.Interior.Color = myColor

    Else
        Dim myRange As Range

        initialPlaceHolderValue = Cells(i, 1).Value
        r = WorksheetFunction.RandBetween(180, 255)
        g = WorksheetFunction.RandBetween(180, 255)
        b = WorksheetFunction.RandBetween(180, 255)
        Cells(i, 1).EntireRow.Interior.Color = RGB(r, g, b)
    End If
Next i

```