below macro code ...
... searches for cells with text entries in column B.
... if found these cells are filled with a cell fill of RGB (222, 222, 222).
This code was furnished courtesy of 'nutsch'. It works very well!
In the meantime new requirements surfaced.
I would like to get this macro tweaked / re-written so that the conditions for the cell fill are as follows:
1) the cell has to have a text entry (ie. not numeric) and
2) one character in these cells has to be a ? (Question mark) and
3) the string must start with a uppercase letter.
I have attached a sample file for your convenience.
Help is much appreciated. Thank you very much in advance.
Dim lLastRow As Long, lLoop As Long
lLastRow = Cells(Rows.Count, "B").End(xlUp).Row
For lLoop = 1 To lLastRow
If Not (IsNumeric(Cells(lLoop, 2))) Then Cells(lLoop, 2).Interior.Color = RGB(222, 222, 222)