You could do the same thing with Conditional Formatting and no macro.

Select rows to highlight then FormatCFFormula is:

=$C1<""

Format to a pattern and OK.


Gord Dibben Excel MVP

On Tue, 6 Dec 2005 20:20:13 -0600, fairy*belle
wrote:


Ok, my question is:

i have 3 columns Name, Amount owed, and Date. I was wondeiring if there
was a macro i could run that highlights the row after i enter the
date... Please HELP