hi,
i have a code below what i want to do is in blue color
Set Range1 = Range("A1:C100").Find("DATA")
If Not Range1 Is Nothing Then
center align then bold format
End If
how do i also, using the range of A1 to C100
find cell that has values of more than 11 characters then make it bold format
and left align
also insert entire row above the cell that has more than 11 characters
Bookmarks