VBA to Highlight Cells w/ Data

[GreatOffender]

I would like to highlight the cells with data in rows R - U. The columns are text and not numeric. I have tried something like the snippet below but have had zero luck. This was stolen from several searches on "how to" but I have not gotten it to work.

If ActiveCell.Value > 0 then
ActiveCell.Interior.Color = vbRed
End If

 

[Joe4]

You could just use something like:

If ActiveCell.Value <> "" then

though I would STRONLGY recommend not looping through and selecting every cell in your range (slow and inefficient).

You also do not need VBA code for this. You can just use Conditional Formatting.