The below code finds a number within a range of number in column b and c and highlights the row. How do I alert the row numbers affected with the below code. Is it possible with the below code?


'get last row
lr = Columns("B:C").Find("*", [b1], , , xlByRows, xlPrevious).Row


'set conditional formatting
With Rows("1:" & lr)



.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=AND($B1<=" & num_cmp & ",$C1>=" & num_cmp & ")"
.FormatConditions(.FormatConditions.Count).SetFirstPriority



        With .FormatConditions(1).Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 0
        .TintAndShade = 0
        .PatternTintAndShade = 0
        
       
        
    End With