Hi all,
I trying to format a row using formulae.

For example:
In cell "A3", if the length of the word is 2, then the Row should be colored grey.

This shud fall into a loop between row 3 to 200.

To begin with, I tried this, (without looping between rows 1 to 200)

Sub Format()
Range("A1").Select
If LenB("A1") = 2 Then
Selection.Interior.ColorIndex = 16
End If
End Sub

But even this didnt work.

Please suggest a solution!

Thanks