Hi rylo,

I tried using

If rCell.Value Like "in progress*" Then
rCell.Interior.Color = &H7AEAEF
End If

but, any word starting with "i" also gets converted to yellow colour.Its not working correctly.

Thanks & Regards,
Preethi.